Can Merge Replication and Mirroring Co-Exist?

Posted on 2011-10-16
Last Modified: 2013-11-05
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?

Question by:townsma
    1 Comment
    LVL 7

    Accepted Solution

    it supports without problems. I have tried it on my test servers and also there is a MS article telling about replicating replication databases:

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now