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

—Gert Drapers
Development Manager
Visual Studio Team System

 

End of Article


You must log on before posting a comment.

If you don't have a username & password, please register now.

 
 

ADS BY GOOGLE