A bLoG by ♚ Suresh babu ♚
Search This Blog
Showing posts with label
TSQL to get current location of all data and log files of all databases of the server
.
Show all posts
Showing posts with label
TSQL to get current location of all data and log files of all databases of the server
.
Show all posts
Wednesday, April 18, 2012
SQL DBA - TSQL to get current location of all data and log files of all databases of the server
SELECT
name
,
physical_name
AS
current_file_location
FROM
sys.master_files
Older Posts
Home
Subscribe to:
Posts (Atom)