Failover Clustering

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Failover Clustering

Failover Clustering

Rate Topic

Display Mode

Topic Options

Author

Message

soccer

Posted Tuesday, September 04, 2012 2:42 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:51 PM
Points: 114, Visits: 97

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

Perry Whittle

Posted Tuesday, September 04, 2012 2:43 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:58 PM
Points: 5,242, Visits: 11,259

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" Wink

Post #1354190

soccer

Posted Tuesday, September 04, 2012 4:24 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:51 PM
Points: 114, Visits: 97

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

Irwan Tjanterik

Posted Wednesday, September 05, 2012 7:50 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, March 20, 2013 5:28 PM
Points: 64, Visits: 282

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

saidapurs

Posted Thursday, September 06, 2012 12:23 AM

SSC-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

Perry Whittle

Posted Thursday, September 06, 2012 1:10 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:58 PM
Points: 5,242, Visits: 11,259

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" Wink

Post #1355071

pan123au

Posted Thursday, September 06, 2012 7:31 PM

Grasshopper

Group: General Forum Members
Last Login: 2 days ago @ 1:18 AM
Points: 14, Visits: 398

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 »

Permissions