Chat now with support
Chat with Support

NetVault Plug-in for Sybase 3.2 - User Guide

Restoring from a Differential Backup scenario

* 
IMPORTANT: To prevent an error from occurring, take the database offline before performing a Differential Restore.

Restore from a Differential Backup: Last Full Backup plus last Differential Backup: Using this strategy, first restore the original Full Backup and then only the subsequent Differential Backup that was performed at the applicable point. Because a Differential Backup involves backing up all data that is new or has changed since the original Full Backup every time, you do not have to restore each individual Differential Backup in the order it was performed. The following example reveals that only the original Full Backup and the most recently performed Differential Backup must be restored to bring a database to its most recently backed-up state.

Figure 2. Example of restore for Differential Backup

Restoring the master database

Sybase requires the database server to be in single-user mode before restoring a master database.

1
Place the database server in single-user mode.
For instructions on this procedure, see the Sybase ASE documentation.
2
Restore the master database backup following the steps in Selecting data for a restore, Setting restore options, Finalizing and submitting the job, and Completing post-restore requirements to initiate the restore.
* 
IMPORTANT: When you restore a master database, verify that the only item selected is the master database.
After the restore job is finished, the Sybase ASE Server shuts down and restarts automatically.

Restoring a nonexistent database

You can restore a database to a Sybase Server that currently does not contain the specified database.

1
Re-create the missing database.
First create a database on the target Sybase Server that is the same as the one to be restored. Accomplish this step by using the Sybase ASE Software Tools or through Sybase ISQL. Verify that the device allocations are the same as or larger than those allocations defined for the original database.
2
Using the steps in Restoring Incremental and Differential Backups, restore the most recent Full Backup for the applicable database.

Renaming a database for a restore

You can rename a database item that is to be recovered during a restore. This process is useful when you must restore a backed-up database item without overwriting an existing one.

1
In the Navigation pane, click Create Restore Job, select Plug‑in for Sybase from the Plugin Type list, select the applicable saveset, and click Next.
For more information, see Selecting data for a restore.
2
Select the applicable database on the Create Selection Set page.
3
From the Actions list, select Rename.
4
In the Rename/Relocate dialog box, enter the new name in the Rename box, and click Ok.
The plug-in updates the database node to display the new name in parentheses.
5
Select the check box for the renamed database item to include it in the restore job.
6
Configure the applicable restore options.
For more information, see Setting restore options.
7
Complete and submit the job.
For more information, see Finalizing and submitting the job.
Upon completion of the job, the renamed item is restored to its original location, but is assigned the new name value.
* 
IMPORTANT: Although you can select the actual Sybase Server client item to perform a restore of an entire Sybase Server backup, you cannot use the Rename functionality at this level of the selection tree.
8
Complete the post-restore requirements.
For more information, see Completing post-restore requirements.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating