hi all,
I am using Sql server as my databse (iMTAS).Due to virus i repaired my server with out taking the database back up.Now i coudnt open the sqlserver.But iMTAS.mdf and iMTAS.ldb are still in the hard disk. I got the Back up of the databse which is one week back and I loded it in a new machine.It is working properly,but the last one week's records are really valuable.How can i retrieve it back and load to the new server.
I tried with sp_attach_db but it shows the following error
Server: Msg 5105, Level 16, State 4, Line 1
Device activation error. The physical file name 'E:\Setup\simmy\imtas.mdf' may be incorrect.
Please help me out
I am using Sql server as my databse (iMTAS).Due to virus i repaired my server with out taking the database back up.Now i coudnt open the sqlserver.But iMTAS.mdf and iMTAS.ldb are still in the hard disk. I got the Back up of the databse which is one week back and I loded it in a new machine.It is working properly,but the last one week's records are really valuable.How can i retrieve it back and load to the new server.
I tried with sp_attach_db but it shows the following error
Server: Msg 5105, Level 16, State 4, Line 1
Device activation error. The physical file name 'E:\Setup\simmy\imtas.mdf' may be incorrect.
Please help me out
