SQL SERVER – Error 9002: The Transaction Log for Database ‘SQLAuthority’ is Full Due to ‘REPLICATION’


 

Recently one of my clients contacted me to provide them assistance in finding and fixing the cause of a huge transaction log file. There are many caused to get error 9002 in SQL Server ERRORLOG. In this blog, I would explain the cause and fix of error: The transaction tog for database ‘SQLAuthority’ is full due to ‘REPLICATION’.

I joined a call with them and ran a few queries to know the state of the database. I always start with the below query.

SELECT name, log_reuse_wait_desc FROM sys.databases where name = ‘Database_Name’

Here is the complete list as of today from books