How to restore a database when one file was losed? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to restore a database when one file was losed?

A disk was failed so the database losed a file which named SubData.ndf.I have a full database backup and the newest of log backup.but I don’t know how to restore it.because the database can’t open.Can you help me ?
Thanks! Jelly.
Restore that full database backup on another server to know the status of the database.
Refer to books online for RESTORE statement topic which refers WITH MOVE option which is useful in this scenario. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>