How to check why transaction log for database is full in Azure SQL

Transaction Logs can be full due to following reason:

· Transaction Log is full due to LOG_BACKUP

· Transaction Log is Full due to ACTIVE TRANSACTION

· Transaction Log is Full Due to REPLICATION

We can use the following query to check the reason of Transaction log full:

SELECT name, [log_reuse_wait_desc] FROM sys.databases WHERE name = 'Your_DB_Name'

Page updated

Google Sites

Report abuse