×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

vcenterlog.LDF

vcenterlog.LDF

vcenterlog.LDF

(OP)
have a file on our vcadmin machine,, taking up lots of gigs.. how do I reduce size, of get rid of??  Looks like the version of the center is 2.5.0.. Ideas, Questions, Answers???  Looks like sone sort of MSSQL file, not sure though..

RE: vcenterlog.LDF

This is an SQL database transaction log file. Talk to your SQL admin about "shrinking" the log file

RE: vcenterlog.LDF

(OP)
Well,,, that was my guess also,, I guess what confused me,, was that it is on the VC admin machine. I looked on our SQL machines,, and their LDF files are there, intact,  does VMware use some sort of sql database internally to keep up with changes??  Anyone??

RE: vcenterlog.LDF

VCenter relies on an SQL database as its back-end. Most common implementations involve SQL Server 2005. I would suggest your review the Vcenter documentation with regards to maintenance of the database

RE: vcenterlog.LDF

To "shrink" the ldf file you would need to use backup sofware to backup the database and then shrink the file (which may not be necessary).

RE: vcenterlog.LDF

Check with your DBA.  You'll want to do one of two things.

1. Schedule Transaction Log backups of this database so that the log can be recovered.

2. Change the database from Full Recovery to Simple recovery so that the transaction log data isn't kept.

If you change the database recovery from full to simple you loose the ability to recover the database to a simple point in time, instead only being able to restore to the latest full backup.

You are taking backups of the vCenter databases so that if you loose the server you can restore and get all your perf data back, right?

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close