How to Restore a Database in SQL Server 2005

Information:

To properly restore a database from backup in SQL Server 2005 perform the following.

 

1)      Open Microsoft SQL Server Management Studio

2)      Login using DBO or Admin permissions

3)      Right Click Databases folder

4)      Select Restore Database…

a.       To database: type the name of the database to restore

b.      Select From Device then click the … button

c.       Click ADD then browse to the file to Restore

                                                               i.      This is usually a *.BAK file

d.      Click OK

e.       Click OK

f.        Check box to Restore the listed database

g.       Click the Options page

                                                               i.      Check Overwrite the existing database

                                                             ii.      Modify the Restore As location as needed for the Database file and the Log file.

                                                            iii.      Click OK

h.       Wait as the Restore takes place

i.         Click OK to acknowledge the restore is completed