SQL Anywhere, on-demand edition Backup and Recovery
Module 5 - Backup and Recovery
When managing many databases, it is important to be able to clearly view the maintenance activities related to them, including backup, recovery, and validation tasks. In this module, you will walk through backing up a database and viewing the list of database backups. You will also learn about the plans for recovery and validation activities.
You should now be familiar with creating a SAP Sybase SQL Anywhere, on-demand edition cloud and adding hosts, servers, and databases to that cloud. It is expected that you have created a cloud with a minimum of two cloud servers, and have added some databases to the cloud.
For more information, please see the earlier tutorial modules.
Backup a Database
You can also create backups from the Cloud Console. Backups created from the Cloud Console or the Cloud Command Utility can be viewed and managed from within the Cloud Console. By default, when you back up a database from the Cloud Console the backup is validated.
To backup a database from the Cloud Console:
- Click Databases in the left hand navigation pane, select the database you wish to backup, and click Back Up.
- Choose the type of validation to perform on the backup, the type of backup you wish to create (full or incremental), and the host where you want the backup to be stored. Click Finish.
Restore a Database
Restoring a database will instantiate a database back to the state it was at the time of the backup.
To restore a database, the database must first be stopped:
- Click Databases in the left hand navigation pane, select the database you wish to restore and click Restore.
- Select a backup to restore. Click Next.
- Select the cloud server where you want the database to be restored to, or create a new database from the backup. Click Finish.
Maintenance plans can be created to schedule automatic backups of a database or a group of databases. Maintenance plans can schedule both full and incremental backups and allow you to decide how often the backups occur, and which host the backups are stored on. The time, day, and frequency of both full and incremental backups can be selected independently. Maintenance plans are very flexible and allow for customization to suit your needs. For example, you can create a plan to create a full backup every Saturday and incremental backups once a day from Monday to Friday. Another example would be to create a full backup only once and incremental backups hourly on Mondays, Wednesdays, and Fridays. The latter example will be demonstrated.
To manage maintenance plans:
- Click Maintenance Plans in the left hand navigation pane and click Create.
- Choose a name for the maintenance plan then continue through the options to select full or both full and incremental backups, and the backup host. Click Next.
- When scheduling the backups, full backups and incremental backups are individually created. Create a full backup schedule then click Next.
- If applicable, create an incremental backup schedule.
- Clicking Finish will create and put the maintenance plan into effect. The maintenance plan will appear in the list in the Manage Maintenance Plans dialog after it has been created.
- After the maintenance plan has been created, you will need to select which databases the plan applies to. Select the maintenance plan you just created by checking the check-box and click Apply Plan.
- A dialog will appear allowing you to choose databases in the cloud. Browse for a database that the maintenance plan should apply to and separate multiple databases with semicolons. Click Next.
- A dialog will appear to confirm databases for the maintenance plan. Confirm the databases and click Finish.
Default Maintenance Plans
Applying a maintenance plan as default will automatically assign all databases newly added to the cloud to the default maintenance plan. However, databases already running in the cloud will not be affected. To apply the default maintenance plan to databases already in the cloud, this step must be performed. For more information about maintenance plans, see http://dcx.sybase.com/index.html#cloud100/en/dbcloud/maintenance-plans.html.