Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

The transaction log for database 'tempdb' is full

Hello,

Can you help me to understand and solve one problem related with tempdb in SQL Server 2008!?

Our SAP system sometimes shows some short-dumps: START_CALL_SICK (Database inconsistency: Start Transaction SICK). In SM21 I see the following error:

Database error 9002 at OPC

> The transaction log for database 'tempdb' is full. To fin

> out why space in the log cannot be reused, see the

> log_reuse_wait_desc column in sys.databases

Database error 9002

When I try to open the properties of the database through SQL Management Studio I see the following error:

I checked the the tempdb disk (5Gb) and in fact it´s full, but I can´t change the disk size...:

Can you tell me why this templog.ldf increased a lot? It´s possible to change the size of this templog.ldf file? How can I disable the option of autogrowth of tempdb? It´s possible?

Kind regards,

samid raif

Former Member
Not what you were looking for? View more on this topic or Ask a question