Table of ContentsView in Frames

Retrieving and restoring remote backups

Retrieving remote backups

To retrieve a remote backup, SnapManager uses the name of the dataset and the SnapInfo directory to create a list of databases that need to be restored.

Restoring remote backups

The process of restoring a remote backup is almost the same as restoring a local backup, except that the remote backup needs to be restored from the archived backup and the backed up transaction logs have to be applied manually.

To restore an archived database from the Restore wizard, follow these steps.

Step Action
1

Select the SQL Server from the Scope pane.

2

Select Restore Wizard from the Actions pane.

Result The Restore wizard opens.

3

Click Next.

Result The "Which SQL Server Created the Backups" window appears.

4

In the "Which SQL Server Created the Backups" window, select the option "Restore from archive."

5

Continue with the instructions provided in the Restore wizard.

6

Click Finish to restore the database from the archived backups.

Deferred database integrity verification

Deferred integrity verification can be performed on the local and the remote backup. Deferred integrity verification can be carried out in two ways:

Deferred integrity verification runs on the management group that you selected previously. The remote backup management group can always be changed after remote backup is created.

You can perform deferred verification on the SnapVault secondary storage system from both the local application server and the remote verification server.

Types of restore operations supported with dataset and SnapVault integration

The following table describes the restore operations supported with dataset and SnapVault integration with SnapManager.

Operation Backup type Restore from archive

Restore system databases

Not supported

Not supported

Restore user databases

Full backup

Automatic

Transaction log backup

Manual

Backup verification during restore

Full backup

Automatic

Transaction log backup

Not supported

Restore when the system databases and the user databases share one LUN

Full backup and transaction log backup

Not supported

Clone user databases

Full backup

Automatic

Transaction log backup

Manual