April 10, 2012 at 5:48 pm
Hi ,i have 3 node cluster and 3 sql instances installed .
All sql disks are mount points(system,temp,data,log).The mount point disk for system dbs for all sql instances is not fail over to node1
error:
Cluster resource 'disk:P_SYSTEM' in clustered service or application 'sqlservice' failed.
The Cluster service failed to bring clustered service or application 'sqlservice' 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.
why system mount point disk for all sql instances not fail over to one node.
April 11, 2012 at 2:38 am
jgflufg (4/10/2012)
Hi ,i have 3 node cluster and 3 sql instances installed .All sql disks are mount points(system,temp,data,log).The mount point disk for system dbs for all sql instances is not fail over to node1
error:
Cluster resource 'disk:P_SYSTEM' in clustered service or application 'sqlservice' failed.
The Cluster service failed to bring clustered service or application 'sqlservice' 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.
why system mount point disk for all sql instances not fail over to one node.
Have you checked the storage has been properly presented to each failover partner?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2012 at 2:55 pm
A few questions ...
What version of Windows Server ?
What type of SAN are you using ?
Are you using any LUN presentation software such as Veritas Volume Manager ?
Have you run cluster verification ?
Are all pieces of software up to the proper maintenance levels ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply