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.
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 integrity verification can be performed on the local and the remote backup. Deferred integrity verification can be carried out in two ways:
SnapManager archives the local backup first, then verifies the backup on the SnapVault secondary storage system.
Both "Archive backup to secondary storage" and "Verify on archived backup on secondary storage" should be enabled.
Both local and remote backup management groups are used. The local backups of the local backup management group are archived using the remote backup management group.
SnapManager runs verification on the backups already archived on the SnapVault secondary storage.
Only "Verify on archived backup on secondary storage" should be enabled, and only the backups of the remote backup management group are verified.
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.
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 |