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)