March 12, 2014 at 7:06 pm
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!
March 12, 2014 at 11:47 pm
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
March 13, 2014 at 5:06 am
Thanks. So when windows reboot, does the sql server service comes online automatically?
March 13, 2014 at 5:13 am
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" 😉
March 13, 2014 at 5:33 am
Thanks a lot!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply