User`s guide

a. Click the Databases drop-down menu.
b. Select the following databases and click OK.
n
CSI_Domain
n
VCM
n
VCM_Coll
n
VCM_UNIX
Do not rebuild the index for the VCM_Raw database.
c. In the Advanced options area, select Sort results in tempdb and click Next.
12. On the Define Update Statistics Task page, define how the maintenance plan will update the database
statistics.
a. Click the Databases drop-down menu.
b. Select the following databases and click OK.
n
CSI_Domain
n
VCM
n
VCM_Coll
n
VCM_UNIX
Do not update statistics for the VCM_Raw database.
13. On the Define History Cleanup Task page, define how the maintenance plan will clean up historical
data from the SQL Server 2008R2 machine and click Next.
a. Select Backup and restore history.
b. Select SQL Server Agent job history.
c. Select Maintenance plan history.
d. Set the cleanup task to remove historical data older than 4 Months.
14. On the Select Report Options page, save a report of the maintenance plan actions.
a. Select Write a report to a text file.
b. Select a folder for the report and click Next.
15. On the Complete the Wizard page, verify your selections in the Maintenance Plan Wizard summary,
expand the selections to view the settings, and click Finish.
16. When the Maintenance Plan Wizard progress is finished, verify that each action is successful.
What to do next
n
You have established a routine maintenance plan to ensure that SQL Server 2008R2 continues to
operate efficiently. To view, save, copy, or send the report, click Report and select an option.
n
Use VCM normally.
Incorporate the VCM CMDB into your Backup and Disaster Recovery
Plans
Consider your VCM configuration management database as any other SQL database in your environment
and incorporate the database into your corporate strategy for backup and disaster recovery.
vCenter Configuration Manager Installation and Getting Started Guide
70 VMware, Inc.