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.

Prerequisites

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.

Results

An image backup is created.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0