question

rob.steven avatar image
rob.steven asked

The transaction log for database 'tempdb' is full

I have only read permission to the client database I'm querying in. The same query was working for since yesterday but today I am encountering the below error in sql server management studio. "The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases" Any thoughts or suggestions on what the cause is or how to resolve it is much appreciated. Thanks in advance!!
sql-servertransaction-logtempdbspace
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image
JohnM answered
The usual suspect is that the drive is out of space. Have you checked that? If the drive runs out of space and the transaction log attempts to grow due to a large transaction it won't be able to and you'll get that error message. I would try to expand the drive to handle the growth of tempdb. Hope that helps!
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Waqar_lionheart avatar image
Waqar_lionheart answered
If its not drive space, check your autogrowth settings.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.