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
