Subscription Materialization for Logical Primary Database

Learn about subscription materialization issues for a logical primary database, and what happens if you execute the switch active command for a logical primary database during subscription materialization.

During subscription materialization, data is selected from the active primary database into a materialization queue.

When you execute the switch active command, the primary Replication Server replicates RSSD information to notify replicate sites that the active database has been changed. When a replicate Replication Server with a materializing subscription receives this information, the materialization queue is dropped. A new queue is built by reselecting the subscription data from the new active primary database.

Note: The Replication Agent for the RSSD of the primary Replication Server must be running for replicate Replication Servers to detect that the active database has been changed.