Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides

Search the VMware Knowledge Base (KB)

View by Article ID

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

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.

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:

Keywords

database data base transaction log logs full vc virtualcenter virtual center

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

1 2 3 4 5
31 Ratings

1 2 3 4 5
31 Ratings

Actions

Bookmark Document

KB:

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)