Launch SQL Management Studio and connect to the server.
Make sure that you do not already have a database with the same name as the database you want to restore.
Right-click the
node in the tree on the left.Select
.Specify the new name for the database in the
field.Select
.Click the
button.Click
and select the file that contains the backup you want to restore.Click
.Select the check box next to the database backup set you want to restore. Only one set should be selected.
Click
in the list on the left.Make sure that the location where the database files will be created is correct. Change the location if necessary.
Click
.