Resolve log_reuse_wait_desc is REPLICATION

Occasionally I come across instances with  the following symptoms:


  • The log file is unable to be shrunk
  • The log file log_reuse_wait_desc is REPLICATION
  • There is no replication setup on the SQL Server instance


The below is an example:



These are the steps you can take to resolve this:




Select the database with the issue



The Snapshot publication is a good option as schema changes are not made



Selecting any sproc is an easy option



You will notice the below objects have now been created and the log_reuse_wait_desc is still REPLICATION





The replication created objects are now gone and the REPLICATION message is gone.


Leave a Reply