Can Merge Replication and Mirroring Co-Exist?

I have a requirement to provide both Merge Replication for distributed processing, i.e. to POS Terminals, but also need to Mirror the master database in case of failure.

We do perform backups also, and the client cannot afford the regular HA options like clustering.

Has anyone tried to impletement both technologies on the same databases?  Does it work?  Are there any caveats I should be aware of?

LVL 6
townsmaAsked:
Who is Participating?
 
Metehan OzculluSQL Service ManagerCommented:
it supports without problems. I have tried it on my test servers and also there is a MS article telling about replicating replication databases:
http://msdn.microsoft.com/en-us/library/ms151799.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.