The transaction log for database 'tempdb' is full
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?