Forum Discussion

Ricky Bennett's avatar
Ricky Bennett
Copper Contributor
Sep 05, 2018

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.

1 Reply

  • Fernando Eggert's avatar
    Fernando Eggert
    Copper Contributor
    Oct 03, 2018
    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.

Resources