Forum Discussion
How can I clear the transaction log when the 'tempdb' is full on Azure SQL Server
How to resolve the error: The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'. on an Azure SQL Database.
Ricky,
You need to reduce the size of your transaction.
Do you know what query is causing the problem, if not, try to use DBCC OPENTRAN to identify the transaction that is causing this issue.
Best regards.
You need to reduce the size of your transaction.
Do you know what query is causing the problem, if not, try to use DBCC OPENTRAN to identify the transaction that is causing this issue.
Best regards.