NORECOVERY Mode Example

Follow these steps:

1. On the Restore screen, select the date for recovery from Recovery Point Date, the scheduled time for recovery from Time Range, the Recovery Point Server (RPS) of an SQL database from the table, and then click Next.
2. On the Restore Options screen, under Destination, select Restore to original location, and then click Next.
3. Note: If the data you attempt to restore is encrypted, provide the password as needed.
3. On the Restore - Job level Options page, do the following, and then click Next:
• For Recovery State, select NORECOVERY Mode.
• For Miscellaneous, select Force restore over existing files or database.
4. 
4. To configure or change the configuration at a database level, click the Configure button.
5. 
6. The Additional Database Options dialog appears.
5. Verify and make any changes to the database options, as needed, and then click OK to return to the Restore Options- Original location page.
6. 
6. Click Next.
7. The Restore Summary page appears.
7. To start the restoring process to the original location, click Finish.
8. 
9. After the restore finishes, view the restore status in the Activity Log. It also provides status information on Database Consistency Check, and Restricted user access.
10. 
11. In the SQL Management studio, the restored database gets updated with a (Restoring…) label in the filename indicating that the database file is no longer accessible.
12. Note: To restore the last backup and bring the database online for usage, use the RECOVERY Mode option.
13.