March 20, 2008 at 1:11 pm
Hi all,
I am looking for a script to check for full transaction logs or near 90%, so I can easily "increase" or "shrink" the log.
Any help appreciated.
marsovac2001
March 20, 2008 at 2:15 pm
Do you mean 90% of current space is in use in the LogFile, or do you mean that 90% of the Maximum size is in use?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 20, 2008 at 3:44 pm
Well assuming that it's the former, "[font="Courier New"]DBCC Sqlperf(Logspace)[/font]" is the command that you want.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply