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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Maintaining Your Database » 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)

  1. Connect to the database as a user with DBA authority.

  2. Right-click the database and choose Create Backup Images.

  3. Click Next.

  4. In the Which Database Do You Want To Back Up list, select the database and click Next.

  5. In the Save The Backup Images In The Following Directory field, type the name of a directory to save the backup copies.

  6. Select an option in the Which Files Do You Want To Back Up list and click Next.

  7. In the What Do You Want To Do With The Transaction Log list, click Continue To Use The Same Transaction Log.

  8. Click Next.

  9. Click Finish.

  10. Click Close.

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 File » Create Backup Images.
  • Right-clicking a database, and choosing Create Backup Images.

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.

See also