Home > SQL Server, T-SQL > T-SQL: Find logical name and physical location of system databases

T-SQL: Find logical name and physical location of system databases

November 3rd, 2009 Zaur Bahramov Leave a comment Go to comments

The following T-SQL statements will print the logical name and physical location of system database files:

USE master;
GO
SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files
WHERE database_id = DB_ID(N'master')

SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files
WHERE database_id = DB_ID(N'tempdb')

SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files
WHERE database_id = DB_ID(N'model')

SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files
WHERE database_id = DB_ID(N'msdb')

Result:

image

Categories: SQL Server, T-SQL Tags: , ,
  1. No comments yet.
  1. No trackbacks yet.

Spam Protection by WP-SpamFree