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.
