Re-Sync after Primary DB load
When loading a dump into a primary database, the connections to the primary and the warm-standby databases need to be dropped and rebuild. In this case, also disable the REP-Agents on both DBs:
use <DB>
go
sp_config_rep_agent <DB>,"disable"
go
Do this step after dropping the replication connections. After loading the dump into the primary database, before [...]