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

Prevent automatc startup of SQL server on Cluster after windows reboot Expand / Collapse
Author
Message
Posted Wednesday, March 12, 2014 7:06 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, June 20, 2014 7:30 AM
Points: 51, Visits: 320
Guys,

I need to disable automatic startup of SQL Server on a 2 node active/passive cluster after Windows reboot.
What is the best way to follow?

Current Plan: I'm thinking of changing the start mode for sql services to 'disable' for both nodes.

Purpose: We are upgrading the disks, all drives are going to be in the new RAID array. We have SAN replication in place which is copying all changes to the new array in a block level. We need to verify all disks are up before enabling SQL, after windows restart.

Please share your thoughts on this.
Thanks!


Post #1550495
Posted Wednesday, March 12, 2014 11:47 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 2:57 PM
Points: 1,194, Visits: 2,211
I think you should take the SQL Server resource Offline which prevents the failover to the other node. Once you are done with the maintenance you can bring the resource back online.

--
SQLBuddy
Post #1550552
Posted Thursday, March 13, 2014 5:06 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, June 20, 2014 7:30 AM
Points: 51, Visits: 320
Thanks. So when windows reboot, does the sql server service comes online automatically?
Post #1550616
Posted Thursday, March 13, 2014 5:13 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:50 PM
Points: 6,191, Visits: 13,340
SQL!$@w$0ME (3/12/2014)
Guys,

I need to disable automatic startup of SQL Server on a 2 node active/passive cluster after Windows reboot.
What is the best way to follow?

If you take the SQL Server resources offline manually in Failover Cluster Manager they will stay offline after a reboot.
If you want the whole group offline after a reboot then simply uncheck the "Autostart" option on the cluster group properties

SQL!$@w$0ME (3/12/2014)
Current Plan: I'm thinking of changing the start mode for sql services to 'disable' for both nodes.

No, don't do this.


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1550617
Posted Thursday, March 13, 2014 5:33 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, June 20, 2014 7:30 AM
Points: 51, Visits: 320
Thanks a lot!
Post #1550631
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse