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

New 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
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.