Introducing Arcserve Backup Agents and Options › Using Agents › Agent for Sybase › Using the Agent for Sybase › Restore › Restore a Sybase Database

Restore a Sybase Database

You can restore a database or a transaction log using the Restore Manager.

To restore a database or a transaction log

1. In Arcserve Backup, open the Restore Manager and select the database sessions you want to restore using either the Restore by Tree or the Restore by Session methods.
2. Click the Destination tab, and select one of the following:
   • The Restore files to their original locations option
   • Another Sybase instance to which you want the database restored

   Note: If the backup session was created in a previous version of Sybase Adaptive Server, the Restore files to their original location option will not work because no instance name was specified for the backup. For files created in a previous version of Sybase Adaptive Server, you must select a specific Sybase instance as a restore destination.

3. Click Submit on the toolbar.

   The Restore Media dialog opens.

4. Select the backup server where you want to run the restore job.

   Click OK.

   The Session User Name and Password dialog opens.

5. Select a session on the Machine tab.

   Click Edit.

   The Enter User Name and Password dialog opens.

6. Specify the User Name and Password for the computer to which you are restoring, and click OK.
7. Click the DBAgent tab.
8. Select a session on the DBAgent tab and click Edit.

   The Enter User Name and Password dialog opens.

9. Specify the user name and password for the database to which you are restoring, and click OK.
10. Click OK on the Session User Name and Password dialog.

    The job is submitted. When the job finishes, a message reporting a successful restore operation appears. After the agent has restored all the sessions successfully, Sybase Adaptive Server sets the status of the restored database to offline.

    Note: When restoring, remember the order in which you backed up the database and the log. For example, if you backed up the database first and then backed up the related logs, you should restore them in the same order.

11. Run the Sybase isql utility either from the interface, or from the command line.

    To run the isql utility from the command line:

    1. Start the isql utility by entering the following command at a command line console:

       Sybase_main_dir\OCSxxx\bin\isql.exe -Ssybase_instance_name -Usa -Ppassword_for_sa
       

    2. Enter the following commands:

       online database DATABASE_NAME
       

       go
       

       The database becomes online.

For more information on using Arcserve Backup to restore files, see the Administration Guide.