Restoring Databases to a Different Sybase Server Instance

Updated

By default, when restoring to a different Sybase Server instance, a database is restored to the same location as source server in the destination server.

You can only restore from a lower version of the software, or the same version of software to a higher version, for example, Sybase 15.5. to 15.7.

If you want to restore the Sybase server to a different path, then follow the Restoring Databases to a New Device procedure.

Before You Begin

  • Verify that page size and the Max page size are the same at the source and destination.

  • Configure the destination server in the CommCell Console.

  • Verify that the SA user name and password are the same for cross machine restore.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > Sybase.

  2. Right-click the instance, point to All Tasks and then click Browse and Restore.

  3. On the Browse and Restore dialog box, click View Content.

  4. From the Browse window, select the databases that you want to restore in the right pane and click Recover All Selected.

    The Restore Options dialog box is displayed.

  5. Select the Destination Server. If the devices are not existing on the destination server, then select Sybase Create Devices. See Restoring Databases to a New Device to create or change the devices on the destination server.

  6. Click OK to start the restore.