Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database maintenance » Backup and data recovery » Backup and recovery plan design

 

Implementing a backup and recovery plan

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.

 Task
  1. Create and verify your backup and recovery commands, including commands for database validation.

  2. Measure the time it takes to execute the backup and recovery commands.

  3. 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.

  4. Set up your backup procedures on the production server.

  5. Monitor backup procedures to avoid unexpected errors. Make sure any changes in the process are reflected in your documentation.

Results

The backup and recovery plan is implemented.

 See also