NDF文件丢失或者损坏是否可以成功附加数据库

曾经看到有人遇到过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