January 10, 2011 at 9:50 am
I am installin SQL 2008 on a 2 node cluster. I am getting a few messages:
1. Cluster_VerifyForErrors Checks if the cluster has been verified and if there are any errors or failures reported in the verification report.Failed The cluster either has not been verified or there are errors or failures in the verification report. Refer to KB953748
or SQL Server Books Online for more information.
2. Cluster_IsDTCClustered Checks whether the MSDTC service is clustered. The MSDTC service is not clustered. Beginning with Windows
Warning Server 2008, SQL Server Setup does not require MSDTC to be clustered. For more information about the benefits of
clustering MSDTC, see http://technet.microsoft.com/en-us/library/cc730992(WS.10).aspx. On earlier operating
systems, the MSDTC service must be clustered for SQL Server Setup and other SQL Server features to work
correctly. You can cluster the MSDTC service using the Windows Cluster Administrator MMC snap-in.
3. Cluster_VerifyForWarnings Checks if the MSCS cluster has been validated and if there are any warnings reported in the MSCS cluster
Warning validation report.The MSCS cluster has been validated but there are warnings in the MSCS cluster validation
report, or some tests were skipped while running the validatation. To continue, run validation from the Windows
Cluster Administration tool to ensure that the MSCS cluster validation has been run and that the MSCS cluster
validation report does not contain errors.
4. IsDomainNetworkTopOfBindingsChecks to see if the computer domain server is on the network that is bound to the top of the network
Warning order. The domain network is not the first bound network. This will cause domain operations to run slowly and can
cause timeouts that result in failures. Use the Windows network advanced configuration to change the binding
order.
Which one of these is the culprit for the failure in #1. Also, do you have to cluster MSDTC? I have always done this in the past on SQL 2000/2005. What do you all recommend?
January 11, 2011 at 1:41 pm
I can only tell you that I cluster MSDTC, it's best to allocate a dedicated lun to it ( doesn't have to be big ) other than that can't help on the others - thankfully installs have all been good!
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
January 11, 2011 at 2:47 pm
How big do you make the LUN for msdtc? Do you know if it required or recommended to be setup? I'm getting the impression it is recommended to have it.
January 11, 2011 at 3:04 pm
What is stored on the LUN?
January 11, 2011 at 10:23 pm
I'd recommend installing the DTC before installing SQL Server.
Herewith some information you can read up on...
http://blogs.msdn.com/b/sqlblog/archive/2006/10/06/msdtc-and-sql-server-on-a-cluster.aspx
http://support.microsoft.com/kb/254321
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 12, 2011 at 10:36 am
Thanks for your reply. Your links are for SQL 2000/2005. It's different with SQL 2008 R2.
January 12, 2011 at 4:16 pm
I have a 10Gb lun. I read somewhere it was recommened to use a dedicated lun - failing that did I really want it on a data/log or backup lun?
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
January 16, 2011 at 1:19 am
the MSDTC, like a quorum LUN, only stores logs and configs. I always size it at 1GB for MSDTC and 512MB for a cluster quorum.
It looks very much like you have cluster validation issues, these need to be resolved before installing SQL Server. Can you post details of the validation errors?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply