Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database maintenance » Backup and data recovery » Server-side backups

 

Creating an image backup (Sybase Central)

Use the Create Backup Images Wizard to create an image backup that copies each database file but leaves the transaction log untouched, allowing you to continue using the existing transaction log.

Prérequis

You must have the BACKUP DATABASE and VALIDATE ANY OBJECT system privileges.

 Task

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. Validate the database. You can use the Validation utility or the sa_validate stored procedure.

  3. Right-click the database and click Create Backup Images.

  4. Follow the instructions in the Create Backup Images Wizard.

    In the What do you want to do with the transaction log list, click Continue to use the same transaction log.

  5. To recover, copy all the files back in place on the database server computer.

Résultat

An image backup is created.

 See also
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0