mardi 12 juillet 2016

How to Attach Database in SQL Server 2008 r2 without index.idx file

I have a database test (test.mdf,test_ldf.log and test_idx.idx). By mistake i deleted test_idx.idx file and due to file was above 20 GB, i by mistake delete the file permanently. I have used all type of recovery software but cant find the file. Unfortunately that database is not backed up, and now SQL server 2008 r2 doesnt let me attach the database.

Is there any way to attach the database test.mdf file without index file?

Error when i try to attach database:

Unable to open the physical file ".idx". Operating system error 2: "2(failed to retrieve text for this error. Reason: 15105)". (Microsoft SQL Server, Error: 5120)

Aucun commentaire:

Enregistrer un commentaire