Thursday, March 22, 2012

Database Mirroring & Replication Considerations

Hi all,

Can a publisher be mirrored? What are the implications, issues, gotchas? Transactional, Merge or Transactional w/ Updating Subscribers is what I'm considering.

Bottom line is I would like to use mirroring, but only one mirror will not suffice.

Thank you in advance.

Ray Nichols

I am using this configuration

Server 1 - data 1 - DR (Mirroring)
Server 1 - Data 1 - Publisher (Replication - Transactional)

also you could refer http://msdn2.microsoft.com/en-us/library/ms151799.aspxsql

No comments:

Post a Comment