Implement a backup and recovery plan to minimize the loss of data in the event of database failure.
Prerequisites
You must have the BACKUP DATABASE and VALIDATE ANY OBJECT system privileges.
Create and verify your backup and recovery commands, including commands for database validation.
Measure the time it takes to execute the backup and recovery commands.
Document the backup commands and create written procedures outlining where your backups are kept. The procedures should identify any naming conventions that are used and the type of backups that are performed.
Set up your backup procedures on the production server.
Monitor backup procedures to avoid unexpected errors. Make sure any changes in the process are reflected in your documentation.
![]() |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |