Quick Tip: Full vCenter Transaction Log Errors

A while ago my vCenter Service shutdown and I could not get it restarted.  I looked in the event logs of the server and found this guy

Log Name:      Application

Source:        MSSQL$SQLEXP_VIM

Date:          11/14/2011 6:02:25 PM

Event ID:      9002

Task Category: (2)

Level:         Error

Keywords:      Classic

User:          SYSTEM

Computer:

Description:

The transaction log for database ‘VIM_VCDB’ is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

Not being a very big database person myself(although I am trying to learn), I found this great article telling me exactly what I needed to do in order to resolve this issue.

I thought this might be helpful

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1003980

Leave a Reply