5.6

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 117.
Create a Maintenance Plan for SQL Server 2008 R2
To ensure that VCM runs at peak performance and requires little operator intervention during its
lifecycle, you must set up a routine maintenance plan. VCM relies heavily on its SQL databases for
operation.
The maintenance plan uses the automated maintenance functions on SQL Server 2008 R2 servers that host
the VCM database.
Procedure
1. Click Start.
2. Select All Programs > Microsoft SQL Server 2008R2 > SQL Server Management Studio.
3. Expand the Management folder, right-click Maintenance Plans and select Maintenance Plan Wizard.
4. On the Maintenance Plan wizard page, click Next.
5. On the Select Plan Properties page, enter a maintenance plan name, select Single schedule for the
entire plan or no schedule, and click Change.
6. On the Job Schedule Properties - Maintenance Plan page, set the scheduling properties to run the
maintenance plan when the SQLserver is idle or has low usage.
7. Click OK to return to the Select Plan Properties page and click Next.
8. On the Select Maintenance Tasks page, select the following maintenance tasks and click Next.
n
Check Database Integrity
n
Rebuild Index
n
Update Statistics
n
Clean Up History
9. On the Select Maintenance Task Order page, order the maintenance tasks and click Next.
10. On the Define Database Check Integrity Task page, define how the maintenance plan will check the
database integrity.
Maintaining VCM After Installation
VMware, Inc.
117