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

SAP Sybase SQL Anywhere, on-demand edition 1.0 Support Package 3 » SAP Sybase SQL Anywhere, on-demand edition 1.0 » Tenant databases » Database backups and maintenance plans

 

Scheduling a backup by creating a maintenance plan

Use maintenance plans to schedule automatic, recurring backups for tenant databases. Apply an existing maintenance plan to a database, or group of databases, running in the cloud.

Prerequisites

You must have the BackupDatabase and RunScheduleTask privileges.

Context and remarks

By default, tenant databases are backed up once a week and have an expiry date that is one week after the backup was created. The number of backups kept after the expiry date is three.

Every time a maintenance plan is run, it deletes all expired backups except a number of the database's most recent backups as specified by the maintenance plan running the backup.

If you created a maintenance plan and made it the default, then it is only applied to databases subsequently added to the cloud. If you want databases currently running in the cloud to use the new default plan, then you must explicitly apply the plan to the databases.

A default plan can be overridden by applying a different maintenance plan to the database.

 Task
  1. In the Cloud Console, navigate to the Maintenance Plans panel.

  2. Click Create and follow the instructions.

  3. Apply the maintenance plan.

    1. Select the maintenance plan.

    2. Click Apply plan and follow the instructions.

Results

The maintenance plan is created and applied to the specified database or group of databases.

Next

To receive notification emails when a scheduled backup fails, configure your subscription settings.

 See also

Setting a default maintenance plan
Viewing the history of a maintenance plan