SharePoint High Availability (HA) Options – DR, SQL database mirroring, log shipping and clustering

Hey!

I got a few requests to have this available online.. its a presentation file I put together on SharePoint 2010 High Availability options with SQL.

Here is a link as promised to my presentation (pptx) on SharePoint 2010 High Availability Options.
It covers some basics on Disaster Recovery, SQL database mirroring, log shipping and clustering with SharePoint with some Technet links.
SharePoint 2010 HA Options

If you can contribute to the links to this file or initiate a discussion, send me an email or comment here.
Appreciate your feedback!

4 thoughts on “SharePoint High Availability (HA) Options – DR, SQL database mirroring, log shipping and clustering

  1. Covered HA options are really a very informative.

    One question Jeremy,

    How can I implement both solutions?

    Clustering (active\passive) – For prevention of hardware failure.
    +
    [Mirroring] – For prevention of clustered shared storage failure.

    Thank you
    Yuvraj

  2. Hi Yuvraj,

    There are a few different scenarios or ‘modes’ that you can consider if you plan on implementing both solutions at the same time.

    1. High-Safety mode Session with Automatic Failover
    – Principal on active node in Cluster A.
    – Mirror on another clustered node on Cluster B or standalone box.
    – Requires a witness server
    – Synchronous database mirroring
    – When cluster failover takes place, the mirror becomes the principal in Cluster B.
    – When the passive node in Cluster A becomes active, it becomes the new mirror.
    – You can fail back and forth.

    2. High-Safety Mode Session Without Automatic Failover
    – Same scenario above except not automatic failover with database mirroring.
    – No witness server required
    – Requires manual intervention to failover database mirroring.
    – Synchronous database mirroring

    3. High-Performance Mode Session
    – Database mirroring Principal will be on the failover clustered instance.
    – If cluster fails, the mirror can be activated.

    Please look at: http://msdn.microsoft.com/en-us/library/ms191309(v=sql.100).aspx

    Hope it helps..

  3. Hi Jeremy,
    Thanks for the valuable inputs.
    I cant download the PPT, land in 404. Can you please make it available?
    I’m planning a no witness mirror and would like to know steps for manual failover and what configurations are required on sharepoint side (apart from having both SQL servers configured whil installing the farm) and which databases must be mirrored for SP to function properly.
    Thanks,
    Mangesh

  4. I also cant download the PPT, land in 404. Can you please make it available?

    Thanks in Advance

Leave a Reply

Your email address will not be published. Required fields are marked *