<div>
Also, you don't have to restart the server, you can compress tempdb just like any other database....<br />
<br />
Brett
</div>


Also, you don't have to restart the server, you can compress tempdb just like any other database....

Brett

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

</div>
</div>


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. 


SQL 2000 Tempdb Filling up Regulary

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.