Tuesday, June 28, 2011

Database Files Location in SQL

Use the following to find the location of all database files (.mdf and .ldf) present in SQL server

SELECT physical_name as Path_Name FROM master.sys.master_files

Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)