-1

Im following the following but still not succeeded

  1. Created empty database TestingDb in sql server 2008
  2. Database(right-click) --> Restore databases
  3. In To DataBase field wrote TestingDb.
  4. Select From devices and browse address of .bak file then ok

Still it's giving an error: System.data.sqlclient: The backup set holds a backup of a database other than the existing 'TestDb' Database

mehdi lotfi
  • 11,194
  • 18
  • 82
  • 128
Abdul Samad
  • 3
  • 3

1 Answers1

1

You don't need to create an empty database in order to restore your backup file.

Use Databases(right-click)\Restore database...

mehdi lotfi
  • 11,194
  • 18
  • 82
  • 128
  • Databases(right-click)\Restore database ., after this it's asking for To data base., What should i select for To data base. ? in To Db list it's showing list of previously made Dbs. – Abdul Samad Jul 24 '14 at 07:35