How can I clear the transaction log when the 'tempdb' is full on Azure SQL Server

Copper Contributor

How to resolve the error: The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'. on an Azure SQL Database.

1 Reply
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.