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!
Best Answer
No, you will have to do a restore. Please see this reference on how to do file and filegroup restores.