I am running SQL server 2000 an a windows platform.
Tempdb is on a separate disk, with about 2,5 gigs of space.
There are 9 databases that access tempdb on the server. My problem is that tempdb does not seem to be clearing old transactions.
It gets full almost once every week and I have to restart the server in order to clear tempdb.
Is there anyone who has a solution.