Summary
This article describes the administrator procedure to restore Advanced Recovery SQL databases (simple recovery mode).
Resolution
To restore an Advanced Recovery SQL database (simple recovery mode):
- In the DPX management console, select Restore > Block .
- Drill down in the source panel and select the database instance to restore from based on the snapshot backup date/time.
- Select the destination location for the database. Do one of the following:
Restore the database to the Original Location, which you set in the destination panel.
Or, restore the database to a new location. To restore to a new location, select the new server database instance in the destination panel. Warning: Do not attempt to restore a database to a new location on the same server without first detaching the original database, see Original SQL DB is Deleted when Restored to an Alternate Location for additional information. - In the task panel, navigate to the Restore Destination Options. Enter the database path in the MSSQL New Location box and the database path in MSSQL New Location Logs that you will restore the data to on the destination server.
- From the Restore Destination Options, ensure that the database does not exist at the destination location. If it does, set the MSSQL With Replace option to Yes to overwrite an existing database without any checks. The tests involved are not always accurate and may cause a restore to fail. Therefore, manually delete the database from the SQL Server Enterprise Manager before performing a restore over an existing database.
- Save the restore job, then run and monitor it. The job monitor window opens where you track the progress of the SQL database restore.
The database appears from within the SQL Enterprise Manager in a Loading state. In this case, the DBA database is highlighted in grey with (DBA Loading) text.
When the restore is completed, the database is recovered.