sql cluster and sharepoint

Posted on 2009-12-23
Medium Priority
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
  • 2
LVL 12

Accepted Solution

mccarthybri earned 1600 total points
ID: 26116781
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

MsShadow earned 400 total points
ID: 26137746
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.

Author Comment

ID: 26151921
thanks...no 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.


Author Closing Comment

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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
Integration Management Part 2
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

807 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