So I have Database Server running SQL Server 2008 R2, but a lot of Database and Drives on the Windows Server, the request is I want to know each location of Data and Log file on the server, I don’t want to right click and see each one of properties of the DB, so do you right ? Open-mouthed smile

Simple answer is I have to execute this query :

SELECT name, physical_name AS current_file_location
FROM sys.master_files

And the result like the following picture below:

image

Advertisements