Replication In Use

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.