Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

open SQL Server Management Studio created one new database which is "house"(db name). Right click on this Databases node | All Tasks | Restore database. Click radio button 'From database'. Then i go to options and select overwrite the existing database and gave the correct mdf and log file on 'restoring as' column. Click 'Ok' I get the following error...... Please help me immediately

System.Data.SqlClient.SqlError: Cannot open backup device 'D:\Program Files\MicrosoftSQLServer(Exp)\MSSQL.1\MSSQL\Backup\test1.bak'. Operating system error 2(The system cannot find the file specified.). (Microsoft.SqlServer.Smo)

share|improve this question

You can't do direct backup/restore from database to other database with MS SQL Server...

Then you select "From database" in database restore options it doesn't mean what selected database will be used as source for restoration. In this case SQL Server Management studio perform a query among the msdb (backup history) to find databases that have been backed up. And last backup file of database selected (D:\Program Files\MicrosoftSQLServer(Exp)\MSSQL.1\MSSQL\Backup\test1.bak in your case) will be used as restore source.

share|improve this answer
how to restore one database to another one database using by 'From Data base' option on sql server 2005 – uma Nov 18 '10 at 9:15
Omg... 1) Backup OLD database to file (e.g. D:\Program Files\MicrosoftSQLServer(Exp)\MSSQL.1\MSSQL\Backup\test1.bak) 2) Try restore with "From database" option again. – Sergey Nov 18 '10 at 9:54

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.