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

• lucky_tyagi11

  Valued Member

  Points: 63

  More actions

  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)

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  Follow

  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