sql-serverfile-formatmdfldf

Is there some documents for mdf, ndf, ldf file format?


Is there some documents for mdf, ndf, ldf file format?

Here the three different file types are belonged to SQL server.

I search the document on internet for a long time, but the result is disappointed. Hope someone can help me!


Solution

  • There is information on the structures of SQL Server files, however, it's by no means as straightforward as a Word or Excel document.

    You can look here for information on .MDF and .NDF (database files), and here for .LDF files (Log files).

    This is MCM (Microsoft Master) level training, and that alone should give you an idea of the level of complexity involved. If you have a corrupt SQL Server database, you should look at restoring a backup, depending on how recent it was.