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

Posted by vishalneeraj-24503 under Sql Server category on 10/20/2014 | Points: 40 | Views : 1419

We can write below query to get current location:-

Select Name as DB_Name,Physical_Name AS Current_File_Location
From Sys.Master_Files;

Bookmark It

Latest Code Snipptes