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


Maintenance plans

To simplify administration, you can set up a maintenance plan for your database that is executed automatically by the database server. A maintenance plan consists of a schedule for performing one or more of the following tasks:

In Sybase Central you create a maintenance plan by using the Create Maintenance Plan Wizard. Only one instance of a maintenance plan can run at a time. Each time the maintenance plan runs, a maintenance plan report is saved in the database. You can view this report from Sybase Central and optionally you can have the maintenance plan report emailed to you after the maintenance plan executes on the database.

Cloud note: This feature is not supported on tenant databases in the cloud.

 Customizing maintenance plans
 Understanding the maintenance plan status

Creating a maintenance plan
Viewing a maintenance plan report
Deleting a maintenance plan