Howto: WSS 3.0 & SQL 2008 High Availability

Posted on 2008-11-11
Last Modified: 2012-05-05
I am looking to implement WSS 3.0 in a high availability enviroment.  High utilization is not really an issue.  I am more worried about uptime.  My solution to this would be to have the following

1. Two internet providers
2. Two Cisco ASA Firewalls (Cisco1, Cisco2)
3. Two Physical Servers (Server1, Server2)
4. Two Virtual Servers on Each physical Server, running Esx 3.5, W2k8, SQL 2008
5.  Server1 would run a VM for the WSS Front End and the other for SQL 2008
6.  Server2 would run a VM for the WSS Front End and the other for SQL 2008
7.  Both Front End VMs would be in the same farm
8. I was hopeing to mirror the SQL 2008 with automatic fail-over??  I hear that is a new feature in 2008 (in regards as "automated").
9. The Ciscos would be setup in a way in which:
A. Both have different internet providers.
B. Cisco1, Cisco2 are uplinked together through the LAN
C. Two network interfaces on each server.
D. Server1 interface on the DMZ of Cisco1 with a Public IP, and the other on Cisco2 with NAT and port forwarding of 443.
E. Server2 intraface on the DMZ of Cisco2 with a Public IP, and the other on Cisco1 with NAT and port forwarding of 443.

I am not use to creating such a high availability enviroment and looking for any suggestions.  With the solutions I provided, I would think I could handle multiple points of failure (internet, router, server, etc), with a simple DNS change, which I could have monitored and outsourced.

I am not too familiar with SQL, let alone mirroring, so that is my biggest concern.  The goal is to have one the other SQL go online automatically when the other fails.  When the failed SQL comes back online, I want that to be seemless as well and I want all data to be replicated from the server with the most current database.  Is this possible?

I was also looking at a solution from DocAve for high availabilty.

I appreciate all the help!

Question by:tyty4u2
    LVL 11

    Expert Comment

    Automatic failover feature is available on SQL Server 2005 and newer versions. It can automatically failover to the mirrored instance, but it does not automatically fall back as you would have to bring the old primary back online and make sure everything is mirror sync'd again, then you can choose to fall back if you want. In additon to the mirrored instances, you will also need to have an instance to behave as a mirror watcher which monitors the mirrored instances.

    Author Comment

    I read somewhere where SQL 2005 did not support automatic failover for Sharepoint, that it had to be scripted.  What is the job of the mirror watcher?  Can you have multiple mirror watchers?
    LVL 11

    Accepted Solution

    Yes, SQL 2005 does support automatic failover. There are 3 modes: High Availability, High Protection, and High Performance. High Availability mode, in which you set transition safety to FULL, is the only mode that supports automatical failover.
    In order to do that, you have to have a mirror watcher (or more accurately termed, "witness server") which monitors the principal and mirror servers to ensure continued connectivities. However, only client applications that use MS SQL Native Client or the MS .NET framework 2.0 Data Provider for SQL Server can support automatical client redirection.
    I have never read about or tried the situation of multiple witness servers, but maybe you can try. The witness process is not heavy duty and you just need to open a listener port on the server, you probably don't need to have multiple ones. However, you will need to configure it on another separate server so that it does not go down together with the principle server.

    Author Closing Comment

    Sorry for the delay in approving the ticket.  Thanks again!

    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

    Suggested Solutions

    Title # Comments Views Activity
    SQL Schedule Job 1 12
    Disable Checkout in SharePoint 2010 3 24
    What does this mean? 6 26
    sql sproc 2 22
    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…
    Data center, now-a-days, is referred as the home of all the advanced technologies. In-fact, most of the businesses are now establishing their entire organizational structure around the IT capabilities.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    732 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

    22 Experts available now in Live!

    Get 1:1 Help Now