I have database with :

-two filegroups (PRIMARY and INDEX)

-three files .mdf(data), .ndf(index) and .ldf(log)

every file is on different disk, yesterday disk where was NDF file crashed so I lost that file. Is there any way to fix database, without restore?


1 Answer 1


Is there any way to fix database, without restore?

No, you will have to do a restore. Please see this reference on how to do file and filegroup restores.

  • TNX. Please, let me ask you one more question. I have only FULL and LOG backups. Is there any way to restore only NDF file with FULL backup file?
    – Cubone
    Sep 15, 2014 at 12:45
  • 1
    Yes, do you file/filegroup restore using the full backup with NORECOVERY, and then restore your log backups sequentially, with the last one specifying RECOVERY. The link I posted in my answer shows how all of that can be accomplished. Sep 15, 2014 at 12:50
  • I understand restore procedure, I was just not sure about restoring only one file(in this case index file). It is great to know that it is possible. Thank you! :)
    – Cubone
    Sep 16, 2014 at 9:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.