<div>
When you can get all users out, run the following commands -<br />
<br />
USE tempdb<br />
BACKUP TRANSACTION tempdb WITH TRUNCATE_ONLY<br />
CHECKPOINT<br />
DBCC SHRINKFILE(1, 10240) &nbsp;-- reduces tempdb.mdf to 10GB<br />

</div>


When you can get all users out, run the following commands -

USE tempdb
BACKUP TRANSACTION tempdb WITH TRUNCATE_ONLY
CHECKPOINT
DBCC SHRINKFILE(1, 10240)  -- reduces tempdb.mdf to 10GB


<div>
It would be advisable to run these statements in a scheduled SQL job every weekend to keep the tempdb size down on an ongoing basis..
</div>


It would be advisable to run these statements in a scheduled SQL job every weekend to keep the tempdb size down on an ongoing basis..

<div>
<div class="content wysiwyg-content">
My database is SQL server 2000. My database size is 27GB. My tempdb size is 100MB including tempdb.mdf=98MB and tempdb.ldf=3MB). Both tempdb.mdf and tempdb.ldf files are auto grow by 10% with unrestricted size. The free hard disk is 12GB. Users can not query. Please give me your advice.
</div>
</div>


My database is SQL server 2000. My database size is 27GB. My tempdb size is 100MB including tempdb.mdf=98MB and tempdb.ldf=3MB). Both tempdb.mdf and tempdb.ldf files are auto grow by 10% with unrestricted size. The free hard disk is 12GB. Users can not query. Please give me your advice.

The log file for database 'tempdb&quot; is full. Backup the transaction log for the database to free up. Error 9002, sererity 17, state 6.

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.

The log file for database 'tempdb&quot; is full. Backup the transaction log for the database to free up. Error 9002, sererity 17, state 6.

The log file for database 'tempdb" is full. Backup the transaction log for the database to free up. Error 9002, sererity 17, state 6.