Help! The log file for database 'tempdb' is full. Back up the transaction log for the database to fr
Posted
by michael.lukatchik
on Stack Overflow
See other posts from Stack Overflow
or by michael.lukatchik
Published on 2010-04-16T21:27:14Z
Indexed on
2010/04/16
21:33 UTC
Read the original article
Hit count: 377
sql-server
|error
We're running SQL Server 2000. In our database, we have an "Orders" table with approximately 750,000 rows. We can perform simple SELECT statements on this table. However, when we want to run a query like SELECT TOP 100 * FROM Orders ORDER BY Date_Ordered DESC, we receive the following message:
Error: 9002, Severity: 17, State: 6 The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
We have other tables in our database which are similar in size of the amount of records that are in the tables (i.e. 700,000 records). On these tables, we can run any queries we'd like and we never receive a message about 'tempdb being full'.
To resolve this, we've backed up our database, shrunk the actual database and also shrunk the database and files in the tempdb system database, but this hasn't resolved the issue.
The size of our log file is set to autogrow.
We're not sure where to go next. Are there any ideas why we still might be receiving this message?
Error: 9002, Severity: 17, State: 6 The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
© Stack Overflow or respective owner
