Cluster setup--system databases

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Cluster setup--system databases

Cluster setup--system databases

Rate Topic

Display Mode

Topic Options

Author

Message

muthyala_51

Posted Monday, March 18, 2013 8:32 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 12:21 PM
Points: 236, Visits: 1,084

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

Massan

Posted Monday, March 18, 2013 9:39 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 2:42 PM
Points: 11, Visits: 327

Post #1432235

muthyala_51

Posted Tuesday, March 19, 2013 7:04 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 12:21 PM
Points: 236, Visits: 1,084

Post #1432627

Perry Whittle

Posted Tuesday, March 19, 2013 9:30 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:45 AM
Points: 5,204, Visits: 11,163

all the shared disks are dependencies otherwise how would the service start

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

"Ya can't make an omelette without breaking just a few eggs" Wink

Post #1432739

Jay Beta

Posted Friday, March 22, 2013 9:48 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, May 20, 2013 12:06 PM
Points: 12, Visits: 59

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

muthyala_51

Posted Friday, March 22, 2013 9:58 PM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 12:21 PM
Points: 236, Visits: 1,084

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

Perry Whittle

Posted Saturday, March 23, 2013 1:43 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:45 AM
Points: 5,204, Visits: 11,163

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" Wink

Post #1434581

Perry Whittle

Posted Saturday, March 23, 2013 1:48 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:45 AM
Points: 5,204, Visits: 11,163

muthyala_51 (3/22/2013)

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" Wink

Post #1434582

Jay Beta

Posted Saturday, March 23, 2013 6:59 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, May 20, 2013 12:06 PM
Points: 12, Visits: 59

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

Jay Beta

Posted Saturday, March 23, 2013 7:55 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, May 20, 2013 12:06 PM
Points: 12, Visits: 59

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 »

Permissions