SQL Server Restore

In this procedure you will find the information how to restore a database from a SQL Backup file:

1. Find the Database backup file that will be restored.
2. Logon to SQL Server Management Studio with administrator rights.
3. In Object Explorer, click + near server and expand the subitems.
4. Right-click Databases and select Restore Database…
5. On the General page, the name of the restoring database appears in the To database list box. To create a new database, enter its name in the list box.
6. In the To a point in time text box, either retain the default (Most recent possible) or select a specific date and time by clicking the browse (…) button, which opens the Point in Time Restore dialog box. In the Point in Time Restore dialog box select date and time to which you want your database restored to.
7. To specify the source and location of the backup sets to restore, click From device.
8. Click browse (…) button next to device selection part which will open the Specify Backup dialog box.
9. On the Specify Backup dialog box click Add to browse and select your backup file. After selecting your backup file click OK to return back to Specify Backup dialog box.
10. After you see you backup file in the Backup Location listbox click OK to return to Restore Database dialog box.
11. On the Select the backup sets to restore listbox, select your backup file by clicking the selection box.
12. To view or select the advanced options, click Options in the Select a page pane.
13. If you have a database with the same name and you want this restore operation to overwrite this database select Overwrite the existing database.
14. If you want your restored database to be only available to the members of db_owner, dbcreator, or sysadmin groups.select Restrict access to the restored database.
15. Optionally, you can restore the database to a new location by specifying a new restore destination for each file in the Restore the database files as grid.
16. The Recovery state panel determines the state of the database after the restore operation. The default behavior is: RESTORE WITH RECOVERY which means the database will be operational and no additional logs will be restored after this. If you select RESTORE WITH NORECOVERY this will leave the database in the restoring state. This allows you to restore additional backups in the current recovery path. If you select RESTORE WITH STANDBY, this will leave the database in a standby state, in which the database is available for limited read-only access. Choosing this option requires that you specify a standby file in the Standby file text box. The standby file allows the recovery effects to be undone.
17. After selecting appropriate options, click OK to begin the restore operation. After the backup job is finished, an information dialog box will appear. Click OK to finish the restore operation.