Process Manager database

Article:HOWTO62377  |  Created: 2011-12-13  |  Updated: 2011-12-20  |  Article URL http://www.symantec.com/docs/HOWTO62377
Article Type
How To


Subject


Process Manager database

Both Symantec Workflow projects and ServiceDesk Solution use this database.

See Preparing to back up.

Microsoft SQL can use the following recovery models to perform a backup:

  • Simple

  • Full

  • Bulk-logged

For performance reasons Symantec recommends that you use a simple recovery model with the Altiris product line, which includes Symantec Workflow and ServiceDesk Solution. This model is defined as follows:

Model

Description

Work loss exposure

Recover to point in time?

Simple

No log backups

Changes since the most recent backup are unprotected.

In the event of a disaster, those changes must be redone.

Can recover only to the end of a backup.

The simple recovery model minimizes administrative overhead for the transaction log because the transaction log is not backed up. However, the simple recovery model does create a work-loss exposure risk if the database is damaged. For this reason the database should be located on a RAID 10 or similarly configured drives to minimize exposure.

Data is recoverable only to the most recent backup of the lost data. You should use a short backup interval to prevent loss of significant amounts of data.

Symantec recommends that you consider using Symantec NetBackup or Symantec Backup Exec, depending on the specific needs of the environment.

Warning:

Even if a database backup has occurred, do not assume that all data has been collected to restore the Workflow project or ServiceDesk to its original state. Be aware that some data may still be lost.


Legacy ID



v64048340_v66564686


Article URL http://www.symantec.com/docs/HOWTO62377


Terms of use for this information are found in Legal Notices