曾经看到有人遇到过NDF文件损坏或者丢失想要通过MDF直接附加数据库,但是结果是失败。在网上也Google了一下看到很多人问这个问题,答案是不可以的。
来自MSDN:FORATTACH requires the following:
· Alldata files (MDF and NDF) must be available.
· Ifmultiple log files exist, they must all be available.
Ifa read/write database has a single log file that is currently unavailable, andif the database wasshutdown with no u