Here's a query which displays the .mdf and .ldf location of all the databases in the server.
SELECT physical_name
FROM master.sys.master_files
Showing posts with label system tables in SQL server. Show all posts
Showing posts with label system tables in SQL server. Show all posts
Data file locations
Thursday, 3 June 2010
Labels:
Data files,
LDF,
master_files,
MDF,
system tables in SQL server
Subscribe to:
Posts (Atom)
