Help! The log file for database 'tempdb' is full. Back up the transaction log for the database to fr

Posted by michael.lukatchik on Server Fault See other posts from Server Fault or by michael.lukatchik
Published on 2010-04-16T21:27:14Z Indexed on 2010/04/16 23:33 UTC
Read the original article Hit count: 371

Filed under:

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.

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: 371

Filed under:

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.

Developer IT