Recovering a SQL database to the same location
Perform the following steps to restore SQL server snapshots to the same location as that of the asset. Before you proceed, note the following:
SQL AG databases do not support recovering to the same location.
The RECOVERY and NORECOVERY restore options are applicable to standalone SQL databases only.
To restore a SQL snapshot to the same location
- Sign in to the NetBackup Web UI.
- From the left navigation pane, click Workloads > Cloud and then select the Applications tab.
- Select the SQL asset that you want to recover, then click View details, and then select the Recovery points tab.
The pane displays all the recovery point snapshots that are available for restore.
- Click to select a recovery point snapshot that you want to use for the restore.
- From the right side, click Recover and then select Original location from the drop-down menu.
- On the Recover to original location dialog box, choose the database recovery options and then click Start recovery to trigger the recovery job.
The following options are available:
Recovery option
Description
Restore with RECOVERY
Select this option if you want to perform a single restore on the database and bring it back to a consistent and operational state.
The database becomes accessible immediately after the restore is complete.
Restore with NORECOVERY
Select this option if you intend to perform multiple database restores from a group of backups. For example, if you want to perform a restore using a full backup snapshot and then restore transaction logs.
The database remains in the restoring state and remains inaccessible. You can work with the database only after the transaction logs are restored with the RECOVERY option.
Overwrite existing database
Select this option if you want the restore operation to replace the original database.
- You can monitor the recovery job from the Activity monitor pane.
A status code 0 indicates that the recovery job is successful. You can now verify that the SQL database is recovered.
