Restoring Databases

Sybase Control Center helps you restore a database backup and its transaction log.

Prerequisites
Decide whether you will load the backup into a new database with the for load option, or into a preexisting database.
Task

You cannot load a database backup that was created on a different operating system, or with an earlier version of Adaptive Server.

  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
  2. Select one of:
    • User Databases
    • System Databases
    • Archive Databases
    • In-Memory Databases
  3. Right-click the Name field of the database you want to back up.
  4. Click the arrow and select Restore.
  5. In the Restore Database wizard, choose from these options:
    Inputs for the Restore Database Wizard

    Input

    Description

    Type of restore

    Restore the entire database or the transaction log.

    Physical file

    Specify the dump device path for the restored database.

    Options
    Optionally, specify:
    • Remote Backup Server name, if different from SYB_BACKUP.
    • A password to access the backup. If you specified a password for backup, the same password must be used while restoring the database.
  6. (Optional) Click Summary to verify your selected options.
  7. Click Finish to start the restore process. Sybase Control Center displays restore messages from the Adaptive Server.
Parent topic: Manage Databases
Related tasks
Backing Up Databases