sql cluster and sharepoint

Posted on 2009-12-23
Last Modified: 2012-10-10
We're installing an SQL Cluster in the next couple of days.  Are there any gotchas as far as SP goes when installing a SQL cluster?  

We've already got the SAN space configured for tempdb, tlog, content dbs, as well as MSDTC and Quorum.  

I'm basically going over this item which seems to be an amazing resource, but if any other thoughts particularly as it relates to SP, please chime in...

Question by:crmsharepoint
    LVL 12

    Accepted Solution

    any gotcha's if there are I havent seen them.  As you know a Sharepoint farm is based on redundency. extra front ends, index servers, all in the name of ensure that no one server or service would bring it down if it died.  Sql cluster is no differant, designed based on if one sql dies there is another to keep in going.  The one thing we did in our shop was to test this cluster from time to time to force the fail-over to occur to ensure it does actually work.  we also setup our two sql servers in the bios so if both servers crashed our primary would reboot and our alternate would not until we manually rebooted it, this way there would be a fit for which one would be the primary.  that was one fail safe we put in place.  only because our setup was prone to power loss at that time.  Otherwise, its a pretty sound deal.  of course also the cluster allow running updates and then rebooting without disruption of service to customers, which is always nice.  So inclosing I hadnt seen any short comings from sharepoint on doing a sql cluster.
    LVL 19

    Assisted Solution

    The only extra advise I can give on top of mccarthybri's excellent explanation is to make sure that the SQL Cluster setup is done by a SQL Pro. In many cases SQL Clusters are setup so poorly that the goal (less risk, more uptime) isn't reached at all, on the contrary.
    LVL 1

    Author Comment

    by:crmsharepoint real gotchas came up as they relate to sp...just some hiccups in the actual SQL install and configuration.....if you don't mind, for my own records and perhaps to someone elses benefit someday, here are some lessons learned...

    1) Make sure that you are logged out of Node B when you are installing on NODE A
    2) We needed domain admin privileges to do the sql install, even though the things we read told us we didn't need domain admin privileges (it consistently failed until we did it with domain admin.
    3) when problems arise look at bootstrap logs, logs in logged in users temp directory, and of course system event viewer
    4) Test failing over of MSDTC, do the SQL cluster install...test failing over of SQL cluster....THEN do SP install
    5) When moving tempdb to a new drive make sure that it is a dependency of the sqlserver instance.  This mistake hosed us when the dba accidentally did this.
    6) if something like #5 happens, you may need to remove all the disks as cluster resources, as well as delete the cluster resource group, then re-add the resource group, and re-add the disks.

    LVL 1

    Author Closing Comment

    done.  thanks, and yes having our dba actually do it was helpful.  

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
    I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
    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…
    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…

    734 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

    24 Experts available now in Live!

    Get 1:1 Help Now