Restore A Database

How to Restore A Database From A Backup

1. Once you are connected to the database engine in Object Explorer, Click the server name to expand the tree view.
2. Expand the databases and select the database you want to restore.
3. Right-Click on the database ans select TASKS  Then RESTORE.
4. Click database, Which will then open the RESTORE DATABASE Dialog Box.
5. On the general page, The name of the database you want yo restore will appear in the  To Database List box. To create a new database insert the name into this box.
6. Keep the default option (Most Recent Possible) in the To A Point In Time text box to get the most recent backup or you can specify a certain date and time by clicking the browse button, This will then open the Point In Time Restore Dialog box.
7. Choose a source and location of the backup sets to restore, You will be given two options. From Database - Enter a database name from the list. From Device - Click the browse button, Which opens the Specify Location Dialog box. In the Backup Media list box, Select one of the listed device types.
8. Select the backups to restore in the Select Backup Sets To Restore Grid. This grid displays the backups available for the specified location. By default, a recovery plan is suggested. To override the suggested recovery plan, you can change the selections in the grid. Any backups that depend on a deselected backup are deselected automatically.
9. In the Restore Options pannel you can choose to Overwrite The Existing Database, Preserve The Replication Settings, Prompt Before Restoring Each Backup, Restrict Access To Restored Database.

10. 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.