Disk Crashed, NDF(Index) file lost

Question

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?

TNX!

Thomas Stringer · Accepted Answer · 2014-09-15 12:35:23Z

5

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.

answered Sep 15, 2014 at 12:35

Thomas Stringer

42.1k9 gold badges117 silver badges154 bronze badges

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.
– Thomas Stringer
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

Add a comment |

1 Answer 1