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


Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.