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?
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx