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