This article revolves around a trivial yet common issue. There might be a set of people for whom the current topic might appear to be insignificant. But I have been asked this question innumerable times, particularly from people who are frequenting using forums or have blog related to storage and highly availability, which instigated me to write this article.
Here goes this frequently asked question.
Question: Is it possible to restore database if one of the files of .mdf (primary data file) or .ndf (secondary data file) is missing?
Answer: In one word the answer is NO. All the .mdf and .ndf files are mandatory to attach or restore database successfully. Even though you have all the transactions stored in .ldf you will not be able to restore the database completely.
I hope this answer removes the cloud of doubt hovering over my targeted readers.
Reference : Pinal Dave (https://blog.sqlauthority.com)