Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cluster setup--system databases Expand / Collapse
Author
Message
Posted Monday, March 18, 2013 8:32 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:26 AM
Points: 381, Visits: 1,857
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?
Post #1432207
Posted Monday, March 18, 2013 9:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 12:01 PM
Points: 36, Visits: 716
.
Post #1432235
Posted Tuesday, March 19, 2013 7:04 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:26 AM
Points: 381, Visits: 1,857


Post #1432627
Posted Tuesday, March 19, 2013 9:30 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:34 AM
Points: 6,192, Visits: 13,343
all the shared disks are dependencies otherwise how would the service start

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1432739
Posted Friday, March 22, 2013 9:48 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 28, 2014 9:37 AM
Points: 12, Visits: 81
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.
Post #1434561
Posted Friday, March 22, 2013 9:58 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:26 AM
Points: 381, Visits: 1,857
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 ?
Post #1434563
Posted Saturday, March 23, 2013 1:43 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:34 AM
Points: 6,192, Visits: 13,343
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"
Post #1434581
Posted Saturday, March 23, 2013 1:48 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:34 AM
Points: 6,192, Visits: 13,343
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"
Post #1434582
Posted Saturday, March 23, 2013 6:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 28, 2014 9:37 AM
Points: 12, Visits: 81
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.
Post #1434604
Posted Saturday, March 23, 2013 7:55 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 28, 2014 9:37 AM
Points: 12, Visits: 81
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.
Post #1434610
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse