Post reply

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

  • June 18, 2016 at 5:57 am

    #314504

    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)

  • June 18, 2016 at 11:38 am

    #1885744

    Don't know what happened to the other thread...

    Was that file in a secondary filegroup, or was it part of Primary?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply