5.7

Procedure
1. Click Start.
2. Select All Programs > Microsoft SQL Server {version} > 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.
a. Click the Databases drop-down menu.
b. Select the following databases and click OK.
n
VCM
n
VCM_Coll
n
VCM_Raw
n
VCM_UNIX
You must select the VCM_Raw database, because it contains transient data that the other databases
consume.
c. Select Include indexes and click Next.
11. On the Define Rebuild Index Task page, define how the maintenance plan will rebuild the Index.
a. Click the Databases drop-down menu.
b. Select the following databases and click OK.
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.
Maintaining VCM After Installation
VMware, Inc.
157