iAnywhere.com - Making a backup, continuing to use the original transaction log

SQL Anywhere® Server - Database Administration > Backup and Data Recovery > Backup and recovery tasks

Making a backup, continuing to use the original transaction log

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)

Start Sybase Central. Connect to the database as the DBA.
Right-click the database and choose Create Backup Images from the popup menu.

The Create Backup Images wizard appears.
Click Next on the introductory page of the wizard.
Select the database that you want to back up.
On the next page, enter the name of a directory to hold the backup copies, and choose whether to perform a complete backup (all database files) or an incremental backup (transaction log file only).
On the next page, select the option Continue To Use The Same Transaction Log.
Click Finish to start the backup.

Tip

You can also access the Create Backup Images Database wizard from within Sybase Central by using any of the following methods:

Selecting a database, and choosing Create Backup Images from the File menu.
Right-clicking a database, and choosing Create Backup Images from the popup menu.

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.

Making a backup, continuing to use the original transaction log

To make a backup, continuing to use the original transaction log (Sybase Central)

Tip

To make a backup, continuing to use the original transaction log (SQL)

To make a backup, continuing to use the original transaction log (Command line)

See also