I want to find an individual database log file. Besides dbcc sqlperf(logspace), is there any T-SQL command that will provide this file?
From the user database context in SQL Server 2000, use the following statement:
SELECT * FROM sysfiles WHERE (status & 0x40 = 0x40)
This statement also works in SQL Server 2005, but a better alternative would be:
SELECT * FROM sys.database_files WHERE type = 1
Visual Studio Team System