Database mirroring–survival kit #3

Now it gets a little bit tricky, because how will you handle databasemirroring and replication together?

Let’s imagine a scenario, where we want to replicate a table from a mirrored database to another database. If we failover, then replication should continue to work. Is that possible?

Yes, and it is fairly easy to setup, what you need to do is:

  1. Setup the mirroring.
  2. Setup a distributor and publication on the current principal server(think about having the distributor on its own server).
  3. On the mirrorserver setup distribution and use the same distributor as on the current principal server.
  4. Add both the distributor and mirrorserver to the replication monitor.
  5. Set –PublisherFailoverPartner property for the agents (in my demo it will be the snapshotagent and the log reader agent.

<—Go to step 2      Go to step 4—>

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s