Blitz Result: Replication In Use
Replication can be used as a high availability or disaster recovery method. It doesn’t manage itself, though – this isn’t one of those set-it-and-forget-it features. Replication can affect things like backup, index maintenance, and code deployments. This part of our SQL Server sp_Blitz script checks sys.databases to see if any of the databases are replication publishers, distributors, or subscribers.
To Fix the Problem
This may not be a problem: it might actually be a solution! This warning is informational just to let you know more about the server you’re dealing with.
Learn More ABout Replication
We’ve written lots of articles on SQL Server replication — check them out here.