Finding Current Location of Data and Log File of All the Database

vishalneeraj-24503
Posted by vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 378
We can write below query to get current location:-
Select Name as DB_Name,Physical_Name AS Current_File_Location
From Sys.Master_Files;

Comments or Responses

Login to post response