InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 01:28:14 GMT20http://www.sqlservercentral.com/Forums/Topic1432207-1549-1.aspxAnd 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.Sat, 23 Mar 2013 07:55:01 GMTJay Betahttp://www.sqlservercentral.com/Forums/Topic1432207-1549-1.aspxLOL, 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.Sat, 23 Mar 2013 06:59:43 GMTJay Betahttp://www.sqlservercentral.com/Forums/Topic1432207-1549-1.aspx[quote][b]muthyala_51 (3/22/2013)[/b][hr]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 ?[/quote]This was usually only experienced on windows 2003 clusters, the service would have to offline before the dependencies could be modified.Sat, 23 Mar 2013 01:48:10 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1432207-1549-1.aspx[quote][b]Jay Beta (3/22/2013)[/b][hr]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..[/quote]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!!!Sat, 23 Mar 2013 01:43:31 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1432207-1549-1.aspxJay,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 ?Fri, 22 Mar 2013 21:58:04 GMTmuthyala_51http://www.sqlservercentral.com/Forums/Topic1432207-1549-1.aspxActually 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.Fri, 22 Mar 2013 21:48:50 GMTJay Betahttp://www.sqlservercentral.com/Forums/Topic1432207-1549-1.aspxall the shared disks are dependencies otherwise how would the service startTue, 19 Mar 2013 09:30:21 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1432207-1549-1.aspx:unsure:Tue, 19 Mar 2013 07:04:16 GMTmuthyala_51http://www.sqlservercentral.com/Forums/Topic1432207-1549-1.aspx.Mon, 18 Mar 2013 09:39:38 GMTMassanhttp://www.sqlservercentral.com/Forums/Topic1432207-1549-1.aspxWe 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?Mon, 18 Mar 2013 08:32:59 GMTmuthyala_51