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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Backup and Data Recovery » Backup and recovery tasks

Renaming the backup copy of the transaction log during backup Next Page

Backing up a database directly to tape

An archive backup makes a copy of the database file and transaction log file in a single archive destination. Only server-side, full backups can be made in this manner. When you make an archive backup in Sybase Central, you have the option of backing up the database directly to tape or to disk.

An extension of .1 is added to the file name you specify in the Backup Database wizard or BACKUP statement.

For more information, see Types of backup.

To make an archive backup to tape (Sybase Central)
  1. Start Sybase Central. Connect to the database as the DBA.

  2. Right-click the database and choose Backup Database from the popup menu.

    The Backup Database wizard appears.

  3. Click Next on the introductory page of the wizard.

  4. Select the database that you want to back up to tape.

  5. On the second page of the wizard, select the On Tape to the Following Device option and enter the tape drive in the text box below.

  6. Click Finish to start the backup.

To make an archive backup to tape (SQL)