VMware
 

Knowledge Base

Search the Knowledge Base:
Products:
Search In:
 

SQL Server Recovery Model Affects Transaction Log Disk Space Requirements

Details

Many customers choose to deploy VirtualCenter 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 VirtualCenter Server database be set to the Simple recovery model. For more information, please see Microsoft SQL Server Books Online and the following Microsoft Web resources:
 
How to stop the transaction log of a SQL Server database from growing unexpectedly
 
Choosing the Recovery Model for a Database
 
View or Change the Recovery Model of a Database

Keywords

database data base transaction log logs full vc virtualcenter virtual center

Feedback

Rating: 1 - Lowest 2 3 4 5 - Highest (3 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? (2000 or fewer characters)
Submit
Rating: 1 - Lowest 2 3 4 5 - Highest (3 Ratings)   
Actions
  • KB Article: 1001046
  • Updated: Aug 14, 2009
  • Products:
    VMware VirtualCenter
  • Product Versions:
    VMware VirtualCenter 2.0.x
    VMware VirtualCenter 2.5.x