User`s guide

Procedure
1. Click Start.
2. Select All Programs > Microsoft SQL Server 2008R2 > SQL Server Management Studio.
3. Expand the SQL instance.
4. Expand Databases.
5. Right-click VCM and select Properties.
6. In the left pane, select Files.
7. In the Autogrowth column, click the ellipsis button.
8. Select Enable Autogrowth.
9. In the File Growth area, select In Percent and type or select 10.
A value of 10% allows the transaction log file to grow by 10% of its current size. This value is critical in
large environments where the log file can increase significantly even when using the Simple recovery
model.
Reserve as much space as possible for your transaction log file so that it does not ever have to grow.
This configuration will result in the best performance.
10. In the Maximum File Size area, select Unrestricted File Growth and click OK.
11. Repeat this procedure for VCM_Log.
What to do next
Return to the database list and set the AutoGrowth value for all VCM-related databases.
Configure Database Recovery Settings
SQL Server supports several database recovery models to control transaction log maintenance. Set a
specific recovery model for each database.
The VCM database settings are set to Simple by default. If you change the VCM database recovery setting
to Full, you must manage your own log backups.
Prerequisites
Understand the database recovery models. See "Database Recovery Models" on page 67.
Procedure
1. Click Start.
2. Select All Programs > Microsoft SQL Server 2008R2 > SQL Server Management Studio.
3. Expand the SQL instance.
4. Expand Databases.
5. Right-click VCM and select Properties.
6. Click Options.
7. In the Recovery model drop-down, select the recovery model and click OK.
What to do next
Create a maintenance plan for SQL Server 2008 R2. See "Create a Maintenance Plan for SQL Server 2008
R2" on page 69.
vCenter Configuration Manager Installation and Getting Started Guide
68 VMware, Inc.