In which Files does SQL Server Actually Store Data?

 Posted by ArticlesMaint on 9/18/2009 | Category: Sql Server Interview questions | Views: 5094

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.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response