Stuart Davies (9/21/2009)
Hi Silverfox,I've updated the stats and this reduces the value to be nearer zero but still a lrage negative value.
dbcc sqlperf(logspace) gives :
DB size %used Status
tempdb49.48438 18.929590
which seems reasonable.
I haven't come across dbcc loginfo before, what am I looking for there?
dbcc loginfo gives you a break down of the log file, into virtual files and shows what is in use (active transactions) status = 2 and the logical fragments of the log file.
--------------------------------------------------------------------------------------
[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]