Tag: replication support only

Reset topology using “Replication Support Only”

If you need to reset your Replication topology you can quickly rebuild subscribers using the “no initialize” also called “Replication Support Only (RSO)”.  WARNING: These steps are designed to remove ALL of your Replication configuration and settings, recreating with new metadata tables. The RSO option skips the Snapshot data reinitialization phase. It only pushed down new
Read More »

Stored Procedure schema changes are not being replicated when using ”initialize with backup”

SQL Replication allows you to replicate user-defined Stored Procedures code to subscribers similar to replicating tables.  When the sp is modified, the new schema/script is transferred to the subscriber. This ensures all subscribers have the most recent version of the SP. Transactional Replication also allows you to setup a subscriber using a backup of the
Read More »