Thursday, August 16, 2012

In which Files does SQL Server Actually Store Data?

Answer:
Any SQL Server database is associated with two kinds of files: *.mdf and *.ldf. *.mdf files are actual physical database files where your data is stored finally. *.ldf (LOG) files are actually data, which is recorded from the last time data was committed in the database.
MDF and LDF files.

No comments:

Post a Comment