TSQL to compare log file to data file in a database

Published 01 August 07 02:07 AM | SQL Master 
SELECT @@servername as ServerName, db_name(database_id) as DatabaseName, Name as LogiCalFileName,

Physical_Name [Physical file], (size*8)/1024 [Size_MB]

FROM sys.master_files

 

Filed under: , ,

Comments

# Other SQL Server Blogs around the Web said on August 6, 2007 9:53 PM:

SELECT @@servername as ServerName , db_name ( database_id ) as DatabaseName , Name as LogiCalFileName

Anonymous comments are disabled

About SQL Master

**__________________________________** SQL Server MVP, Sr. DBA & industry expert. - Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.