DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In
steve gray 8/9/2011 7:24:59 AM

Query to get the names and locations of SQL logs and database files

I have occasion to look at large servers, and as part of that process I need to look at all the files to see if they're ok, I'm particularly interested in the size of the log files (we might need to shrink them)

 This query will quickly show you where they all are

 

Version: Unknown or N/A
Section: SQL Scripts