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

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


Scheduling a backup by creating a maintenance plan

Create a maintenance plan and apply it to a database, or group of databases, running in the cloud.


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.

  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.


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


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