«

»

Sep 29

vCenter 5 Upgrade Gotcha (well me anyway) – DB Recovery Model Changed to Bulk-logged.

Last night my vCenter server ran out of disk space. The transaction log for the vCenter DB filled until there was no more space on disk available for vCenter server services to write to so the the service stopped.

I received an email alarm early in the AM – “The transaction log for database ‘vCenter’ is full.” A quick check of the server showed the drive where the DB is stored was completely full and the DB transaction log was giant. Digging a little deeper I discovered the Recovery Model for the vCenter DB was no longer set to Simple, it had been changed to Bulk-logged.

It appears that when upgrading from vCenter 4.1 to vCenter 5 the recovery model for the vCenter database is changed to Bulk-logged as part of the upgrade process. Changing this back to simple and recovering the disk space is fairly easy and instructions can be found in the VMware KB article Troubleshooting transaction logs on a Microsoft SQL database server.

Searching through the KB it looks like this has been happening with upgrades since version 2.x. The Known issues when installing or upgrading vCenter Server KB article only makes mentions through version 4.x. It looks like there may be some of the same issues when updating to vCenter 5, though I could find anything in the KB that specifically mentioned these issues with 5.

Just a heads up for anyone that may be upgrading to vCenter 5. After you upgrade you may want to check the recovery model settings for you DB.

About the author

vHersey

Hersey Cartwright is an IT professional with extensive experience designing, implementing, managing, and supporting technologies that improve business processes. Hersey is Solutions Architect for SimpliVity covering Virginia, Washington DC, and Maryland. He holds the VMware Certified Design Expert (VCDX-DV #128) certification. Hersey actively participates in the VMware community and was awarded the VMware vExpert title in 2016, 2015, 2014, 2013, and 2012. He enjoys working with, teaching, and writing about virtualization and other data center technologies. Follow Hersey on Twitter @herseyc

1 ping

  1. Database Fun In The Lab « Virtual Potholes

    […] and then I ran into an issue regarding database logging setups that Hersey Cartwright already documented. Set the database […]

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

5 × 2 =