Use this procedure if you want to restore a backup to a different database on the same server or to a database on a different server.

1. Right-click on the database you want to restore the backup to.
2. Select "All Tasks" > "Restore Database...".
3. If you want to create a new database using the backup, type in the new database name in the "Restore as database" dropdown, otherwise select the database you want to overwrite and restore the backup to.
4. Select to restore "From Device".
5. Click "Select Devices", the "Add...".
6. Choose "Filename" and then browse for your backup file.
7. Click "OK".
8. Click "OK" again to return to the "Restore database" window.
9. Click on the "Options" tab.
10. If you are overwriting an existing database, check "Force restore over existing database.".
11. In the "Move to physical file name" column, rename the old database name with your new database name.
    1. You must rename the data and log files if the database you are restoring from still exists on the same server. In this case you are making a copy of your database.
    2. Data and Log files should be named: <your database name>_Data.MDF and <your database name>_Log.LDF respectively.
12. Click "OK" and the restore operation should complete.