Tuesday, September 7, 2010


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 :).

No comments:

Post a Comment