This task describes the simplest kind of backup, which leaves the transaction log untouched.
For more information about when to use this type of backup, see A backup scheme for when disk space is plentiful.
To make a backup, continuing to use the original transaction log (Sybase Central)
Connect to the database as a user with DBA authority.
Right-click the database and choose Create Backup Images.
In the Which Database Do You Want To Back Up list, select the database and click Next.
In the Save The Backup Images In The Following Directory field, type the name of a directory to save the backup copies.
Select an option in the Which Files Do You Want To Back Up list and click Next.
In the What Do You Want To Do With The Transaction Log list, click Continue To Use The Same Transaction Log.
You can also access the Create Backup Images Database Wizard from within Sybase Central by using any of the following methods:
The procedure describes a client-side backup. There are more options available for this kind of backup.
If you choose a server-side backup, and the server is running on a different computer from Sybase Central, you cannot use the Browse button to locate a directory in which to place the backups. The Browse button browses the client computer, while the backup directory is relative to the server.
To make a backup, continuing to use the original transaction log (SQL)
If you are using the BACKUP statement, use the following clauses only:
BACKUP DATABASE DIRECTORY directory-name [ TRANSACTION LOG ONLY ];
Include the TRANSACTION LOG ONLY clause if you are making an incremental backup.
To make a backup, continuing to use the original transaction log (Command line)
If you are using the dbbackup utility, use the following syntax:
dbbackup -c "connection-string" [ -t ] backup-directory
Include the -t option only if you are making an incremental backup.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|