SQL 2008 Mirroring HA option for MOS2007 Sharepoint Farm

Posted on 2011-10-19
Last Modified: 2012-08-13
Hello there,

We are planning to implement SQL 2008 DB mirroring as HA solution to MOS2007 SP farm. But MOS2007 is not DB Mirror aware.
Is this going to be an issue?

Please advise.

Thanks and Regards
Question by:goprasad

    Author Comment

    Any one?
    LVL 6

    Expert Comment

    Yes, you can set-up DB Mirroring of SharePoint Databases.
    But there are a few considerations if it's to be used as a Failover system...

    The main one being that the mirror database is likely to reside on another SharePoint Server (different name). Therefore, you will need to use the stsadm command to "re-point" the database to the proper server name.

    Hope this helps


    Author Comment

    Can you please explain what happens when failover occurs? Whats steps do we need to undertake to redirect traffic from front-end servers to Mirror server
    LVL 6

    Accepted Solution

    When failover occur (assuming you are not using a Witness in your mirroring for auto failover), you need to set the failover database to "normal mode" so you can actually select it.

    You then use the stsadm command on the Web Front-End Server(s) to re-map SharePoint to the proper database server.
    The first database you need to worry about is of course the Config Database.

    Have a look at

    Also another method can be found at:

    One solution might be to:
    - create a brand new farm on the new server
    - mirror the Content DB from production to the failover system (not the config database!)
    - When failing over, enable the mirrored Database.
    - Using stsadm on the WFE Servers, re-attach the mirrored content database to the new (failover) environment.
    - Re-create the search database.

    I haven't try that solution yet but it might work without creating too much overhead...


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
    I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    728 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

    19 Experts available now in Live!

    Get 1:1 Help Now