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!