5.8

n Full Recovery. The transaction log retains all information until it is purged through the SQL Server
LOG backup operation, which the database administrator uses to perform point-in-time recovery. Full
recovery allows incremental backups of the database. Do not use point-in-time recovery, because
certain factors in VCM weaken the point-in-time recovery model. If you implement Full Recovery, you
must set up scheduled daily backups of the transaction log. The log files will continue to grow and
accumulate changes until you back them up. A Full Recovery database that does not have scheduled
backups can fill its disk and stop the system.
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
n Understand the database recovery models. See "Database Recovery Models" on the previous page.
Procedure
1. Launch SQL Server Management Studio.
2. Expand the SQL instance.
3. Expand Databases.
4. Right-click VCM and select Properties.
5. Click Options.
6. In the Recovery model drop-down, select the recovery model and click OK.
What to do next
Create a maintenance plan for SQL Server. See "Create a Maintenance Plan for SQL Server" below.
Create a Maintenance Plan for SQL Server
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 servers that host the
VCM database.
Procedure
1. Launch SQL Server Management Studio.
2. Expand the Management folder, right-click Maintenance Plans and select Maintenance Plan Wizard.
3. On the Maintenance Plan wizard page, click Next.
4. On the Select Plan Properties page, enter a maintenance plan name, select Single schedule for the
entire plan or no schedule, and click Change.
5. 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.
6. Click OK to return to the Select Plan Properties page and click Next.
7. On the Select Maintenance Tasks page, select the following maintenance tasks and click Next.
vRealize Configuration Manager Advanced Installation Guide
164
VMware, Inc.