September 4, 2012 at 2:42 pm
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.
September 4, 2012 at 2:43 pm
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" 😉
September 4, 2012 at 4:24 pm
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.
September 5, 2012 at 7:50 pm
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
September 6, 2012 at 12:23 am
Hi,
Before you install please add the Storage, Msdtc and Quorum drive.
Satish
September 6, 2012 at 1:10 am
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" 😉
September 6, 2012 at 7:31 pm
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.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply