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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Maintaining Your Database » Backup and data recovery


Creating a maintenance plan

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 on a database:

You create a maintenance plan from Sybase Central using the Create Maintenance Plan Wizard. Each time the maintenance plan runs, a maintenance report is saved in the database. You can view this report from Sybase Central, or you can have the maintenance log emailed to you after each time the maintenance plan executes on the database.

To create a maintenance plan

  1. Connect to the database as a user with DBA authority.

  2. In the left pane, right-click Maintenance Plans and choose New  » Maintenance Plan.

  3. Follow the instructions in the Create Maintenance Plan Wizard.

    For more information about the available settings, see:

To view the maintenance report

  1. After the maintenance plan is executed, connect to the database as a user with DBA authority.

  2. In the left pane, double-click Maintenance Plans.

  3. Double-click your maintenance plan.

  4. In the right pane, double-click the report.

    The Maintenance Plan Properties window appears. The Details pane contains the log for the maintenance plan.