vCenter

 View Only

  • 1.  Extremely Large log file C:\ running out of Space

    Posted Sep 22, 2009 09:26 AM

    Hi All,

    We're having an issue with our VCenter the server is running low on resources. The hard drive is partitioned into a C: and D: drive. The C: had only 5MB space free on it.

    We did some investigating looked at teh SQL logs, which were very small, but in the directory where the databases are stored we saw one file in there called ‘ESX-Vmotion_Log.LDF’ which is 75 Gb in size.

    Does anybody know is this important or if it is safe to delete it so as to free up space on our C:\ drive?

    Thanks



  • 2.  RE: Extremely Large log file C:\ running out of Space
    Best Answer

    Posted Sep 22, 2009 10:09 AM

    Hm, thatts definitely an SQL Server Log. Is there a database refering to this name in your SQL?

    Kind Regards,

    Gerrit Lehr

    If you found this or other information useful, please consider awarding points for "Correct" or "Helpful".



  • 3.  RE: Extremely Large log file C:\ running out of Space

    Posted Sep 22, 2009 11:27 AM

    Yes there is.



  • 4.  RE: Extremely Large log file C:\ running out of Space

    Posted Sep 22, 2009 11:45 AM

    Well then backing up the DB should reduce the Logfile size. Would be interessting to fing out what it is for tho. It's not your virtual center DB, is it?

    Kind Regards,

    Gerrit Lehr

    If you found this or other information useful, please consider awarding points for "Correct" or "Helpful".



  • 5.  RE: Extremely Large log file C:\ running out of Space

    Posted Sep 22, 2009 01:40 PM

    I've attached some screen shots to give you a better picture of whats going on. 78GB seems alot for a log file.



  • 6.  RE: Extremely Large log file C:\ running out of Space

    Posted Sep 22, 2009 02:00 PM

    Well, looks like the only VMware related Database since all the others are standard SQL DBs.

    If you never made a backup of the database, the size is absolutly since the LDF contains Transcation Logs. That means you commit an INSERT Statement to the DB = The DB grows, the Logs grow - You commit an DELETE Statement to the DB = The DB gets smaller, the Logs grow again since they store every transaction made to the DB. Backup the Database and the LDF size should be a lot less!

    Kind Regards,

    Gerrit Lehr

    If you found this or other information useful, please consider awarding points for "Correct" or "Helpful".



  • 7.  RE: Extremely Large log file C:\ running out of Space

    Posted Sep 22, 2009 01:59 PM

    Instructions for extending the c:\

    http://vmprofessional.com/index.php?content=2k3resize



  • 8.  RE: Extremely Large log file C:\ running out of Space

    Posted Sep 22, 2009 02:22 PM

    Thanks that could come in handy in the future but my VCentre is running on a physical machine.



  • 9.  RE: Extremely Large log file C:\ running out of Space

    Posted Sep 22, 2009 02:02 PM

    have a look at this as well

    http://www.vmware.com/files/pdf/vc_microsoft_sql_server.pdf