If you are using SQL server then it is obvious that you will face problem some or the other day with it. There are many users who come across several database problem especially when lots of information are stored on it. The data stored in the database are known as MDF files. Generally SQL server consists three types of files which are MDF, NDF and LDF.