SQL Server Transact-SQL (SSQA.net) : TSQL to compare log file to data file in a database

TSQL to compare log file to data file in a database

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

Published Wednesday, August 01, 2007 2:07 AM by SQL Master

Filed under: tsql, log file, data file

Comments

# TSQL to compare log file to data file in a database

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

Monday, August 06, 2007 9:53 PM by Other SQL Server Blogs around the Web

Anonymous comments are disabled