SQL SERVER: RESTORING DATABASE

When you are getting this error means you have already created a database object and you are trying to restore database over it.

All you need to do is to delete the existing database on which u are trying to restore database. Then follow the following steps:

1. Right click the Databases node in the object explorer and click Restore Database…
   
   
2. Under the head of Source for restore select From device: then click this  button.
3. Specify Backup widow will be opened. Click Add button to specify backup file.
4. Locate the backup file.
   NOTE: if file is not present in the location where it is, make sure to select All Files(*) in the Files of type.
5.  Press OK, and again press OK.
6. Then select Restore checkbox from the Select the backup sets to restore: grid.
7. In the To database: select the database.
   NOTE: in this dropdown a database having the same name as your database will be present, select it.
8. Press OK.
9. Following successful message will be appeared.

 

Have a nice day :).