What is the name of the System table from where we can read the Master Files (.mdf, .ldf) Path?

 Posted by Lakhangarg on 10/28/2009 | Category: Sql Server Interview questions | Views: 4541

From sys.master_files table we can find the master file information for mdf file file_id is 1 and for ldf its value is 2.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response