October 13, 2009 at 9:48 am
How to check for space for a Log File
October 13, 2009 at 9:50 am
Krasavita (10/13/2009)
How to check for space for a Log File
This is one way
dbcc sqlperf(logspace)
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 13, 2009 at 10:08 am
Krasavita (10/13/2009)
How to check for space for a Log File
Error log, event log, maintenance plan history log, transaction log???
Assuming you mean transaction log, do you want the size of the log, the amount of space free in the log file, the amount of space used in the log or something else?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply