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.

Return to sp_Blitz or Ask Us Questions