Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Failover Clustering Expand / Collapse
Author
Message
Posted Tuesday, September 4, 2012 2:42 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, July 19, 2014 10:09 PM
Points: 118, Visits: 146
I just added a third node to the existing 2 nodes SQL 2008 enterprise cluster. I attempted to failover to the new node (the third node), resources were not moved over and I received this error in the systems logs.

"The Cluster service failed to bring clustered service or application 'Available Storage' completely online or offline. One or more resources may be in a failed state. This may impact the availability of the clustered service or application."

Could anyone please assist me if you happen to know the solution to this issue?

Thanking you in advance.
Post #1354185
Posted Tuesday, September 4, 2012 2:43 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 6,466, Visits: 13,921
confirm what steps you took to add the node into the windows cluster and into the clustered sql server instance

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1354190
Posted Tuesday, September 4, 2012 4:24 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, July 19, 2014 10:09 PM
Points: 118, Visits: 146
First thing, I added new server into windows cluster.

Secondly, I installed SQL on the new server and added the node into the SQL cluster. The logs indicates clear install.
Post #1354243
Posted Wednesday, September 5, 2012 7:50 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 5:13 PM
Points: 64, Visits: 298
Hi

You need to make sure that the storage is made available to the new node.

You can set this up in the Failover cluster administration under storage area.

Regards

IT
Post #1354986
Posted Thursday, September 6, 2012 12:23 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:06 AM
Points: 167, Visits: 414
Hi,
Before you install please add the Storage, Msdtc and Quorum drive.

Satish
Post #1355039
Posted Thursday, September 6, 2012 1:10 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 6,466, Visits: 13,921
soccer (9/4/2012)
First thing, I added new server into windows cluster.

Secondly, I installed SQL on the new server and added the node into the SQL cluster. The logs indicates clear install.

I'm looking for more detailed info than this!


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1355071
Posted Thursday, September 6, 2012 7:31 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 31, 2014 8:52 PM
Points: 14, Visits: 498
Can Msdtc drive be seen at Failover cluster administration tool of your third node ? If Yes, try failover Msdtc drive to third node. If No, storage is not avaialbe on third node.

Please let me the result.



Post #1355686
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse