VMware Cloud Community
Newbee09
Contributor
Contributor
Jump to solution

Extremely Large log file C:\ running out of Space

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 😧 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

Reply
0 Kudos
1 Solution

Accepted Solutions
Gerrit_Lehr
Commander
Commander
Jump to solution

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".

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

View solution in original post

Reply
0 Kudos
8 Replies
Gerrit_Lehr
Commander
Commander
Jump to solution

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".

Kind regards, Gerrit Lehr If you found this or other information useful, please consider awarding points for "Correct" or "Helpful".
Reply
0 Kudos
Newbee09
Contributor
Contributor
Jump to solution

Yes there is.

Reply
0 Kudos
Gerrit_Lehr
Commander
Commander
Jump to solution

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".

Kind regards, Gerrit Lehr If you found this or other information useful, please consider awarding points for "Correct" or "Helpful".
Reply
0 Kudos
Newbee09
Contributor
Contributor
Jump to solution

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

Reply
0 Kudos
bulletprooffool
Champion
Champion
Jump to solution

Instructions for extending the c:\

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

One day I will virtualise myself . . .
Gerrit_Lehr
Commander
Commander
Jump to solution

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".

Kind regards, Gerrit Lehr If you found this or other information useful, please consider awarding points for "Correct" or "Helpful".
Reply
0 Kudos
Newbee09
Contributor
Contributor
Jump to solution

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

Reply
0 Kudos