I want to find an individual database log file. Besides dbcc sqlperf(logspace), is there anycommand 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