If you regularly plan on creating a backup for a certain database, use the Backup and Restore nodes in the Enterprise Manager. These will use backup and restore projects, saved to a file, so you can re-use them at a later time.
Double-click the Backup node to show a window with the details below.
Note:
| • | Database Workbench does not perform the backup, it instructs Sybase Anywhere to create a backup and waits for the result. |
Backup Database Options
Click OK to start the backup, this might take a while and Database Workbench will be unavailable while waiting for Sybase Anywhere to finish the backup.
An explanation of the options:
Server |
Server alias.
|
Database |
A drop down with all available databases on the given server.
|
To folder/To file |
Select whether to create an image or archive backup.
|
Backup what |
Select to backup the main database file, the transaction log or both.
|
Transaction log |
Select the action to take for the log when backing up.
|
Options |
Additional options for creating the backup. |
See also: Restore Database