SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Cluster setup--system databases


Cluster setup--system databases

Author
Message
muth_51
muth_51
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2537 Visits: 2928
We created a single node cluster and installed sql server failover cluster on it. Plan is to move LUNS and attach the drives to the cluster. Do system db disk needs to be part of dependencies list in the sql server service in clustering?
Nassan
Nassan
SSC Veteran
SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)

Group: General Forum Members
Points: 205 Visits: 876
.
muth_51
muth_51
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2537 Visits: 2928
Unsure
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)

Group: General Forum Members
Points: 54147 Visits: 17684
all the shared disks are dependencies otherwise how would the service start

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
Jay Beta
Jay Beta
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 120
Actually from what I understand not all shared disks are dependencies for the SQL Server resource. The Quorum and DTC LUNS will not be able to be added as dependencies yet they are shared disks. However, to answer the original question, yes whatever shared drive your system dbs are pointed to will have to be added as dependencies for the SQL Server resource. Don't forget to restart the SQL Server resource from within configuration manager for the new settings to be applied. Otherwise SQL will not start as it was pointed out before.
muth_51
muth_51
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2537 Visits: 2928
Jay,

We tested it on the dev servers and we never had any issue with shared drives. We never restarted the service. I am not sure why you wanted to do a restart of the service after adding the disks as dependencies ? Can you please explain in detail ?
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)

Group: General Forum Members
Points: 54147 Visits: 17684
Jay Beta (3/22/2013)
Actually from what I understand not all shared disks are dependencies for the SQL Server resource. The Quorum and DTC LUNS will not be able to be added as dependencies yet they are shared disks..

Maybe i should have spelt it out, all shared disks that are part of the resource group which the instance will use.

If you read the original post above the OP asked if the disk the system dbs are on has to be a dependency or not, they didn't mention quorum, dtc or any other application group!!!

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)

Group: General Forum Members
Points: 54147 Visits: 17684
muthyala_51 (3/22/2013)
Jay,

We tested it on the dev servers and we never had any issue with shared drives. We never restarted the service. I am not sure why you wanted to do a restart of the service after adding the disks as dependencies ? Can you please explain in detail ?

This was usually only experienced on windows 2003 clusters, the service would have to offline before the dependencies could be modified.

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
Jay Beta
Jay Beta
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 120
LOL, Perry, please don't take it personally. You mentioned ALL shared disks and since quorum and DTC are shared disks hence my posts was valid regarding that even know they were not explicilty stated. It was more of a clarification. Thats why I mentioned that the system dbs are on shared drives. Its semantics and no one is questioning your knowledge.
Jay Beta
Jay Beta
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 120
And Perry is correct, there is no need for the SQL Server resource to be restarted under 2008 R2 when adding a dependency. That was only necessary under Server 2003, my apologies.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search