Chat now with support
Chat with Support

NetVault Plug-in for Sybase 11.4.5 - 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.

Restoring the master database

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

IMPORTANT: When you restore a master database, verify that the only item selected is the master database.

Restoring a nonexistent database

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

First create a database on the target SAP ASE Server that is the same as the one to be restored. Accomplish this step by using the SAP ASE Software Tools or through SAP ASE 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 SAP ASE from the Plugin Type list, select the applicable saveset, and click Next.
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.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating