Search the VMware Knowledge Base (KB)
View by Article ID

SQL Server Recovery Model Affects Transaction Log Disk Space Requirements (1001046)

  • 49 Ratings

Details

Many customers choose to deploy vCenter Server with a Microsoft SQL Server database. SQL Server offers administrators a choice of recovery models, which is the primary factor that determines transaction log disk space requirements. The Full recovery model is the default and has the potential to consume all available disk space, if appropriate database maintenance is not performed.

Note: This issue can also affect the vCloud Director database and the solution provided is applicable.

Solution

For sites that do not intend to schedule regular backups of the database transaction logs, VMware suggests that the vCenter Server database be set to the simple recovery model.
 
For more information, see Microsoft SQL Server Books Online and these Microsoft Web resources:

Additional Information

For translated versions of this article, see:

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 49 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.

What can we do to improve this information? (4000 or fewer characters)




Please enter the Captcha code before clicking Submit.
  • 49 Ratings
Actions
KB: