Microsoft SQL can use the following recovery models to perform a backup:
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:
Work loss exposure
Recover to point in time?
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.
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.
Imported Document ID: HOWTO62377
Subscribing will provide email updates when this Article is updated. Login is required.