October 13, 2010 at 1:23 pm
We have an Active\Passive cluster running and we have the need to clone it. (the Cluster lives at a hosting company)
What I want to do is bring SQL Server down while they do the actual server backups and have it still be down after they restore them to the new Servers until we are sure that the SAN drives are done replicating.
What is the best way to do this? If this was a standalone server, I would just stop the SQL Server Services and set them to manual... but I know in a Cluster you really should not use the Services applet to stop and start SQL Server.
Should I take the stop the SQL Server Services another way and then take the Cluster group offline? is there a better way???
October 13, 2010 at 1:30 pm
You can use SQL Server Configuration Manager or Cluster Admin. I believe I would set the group "offline" in Cluster Admin which I believe stops it as well, but if it does not then go into SQL Server Configuration Manager and disable the service.
See the section "Start and stop SQL Server services" of the KB article.
I believe setting the group offline prevents it from failing over, I'm a little rusty on cluster admin use. 😀
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
October 13, 2010 at 1:45 pm
Same here.. very rusty : )
October 14, 2010 at 3:57 am
as soon as you install SQL Server into a clustered environment it sets the service startup to manual on all nodes (imagine if 2 nodes both had the services set to auto!!!).
Taking a group offline and then rebooting the server should keep that group offline as this was the state before the reboot.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2010 at 5:22 am
Thank you!!!
Do you think I should only take the Cluster Group offline or should the the Disk Group and MSDTC group also be taken offline?
October 14, 2010 at 7:58 am
Are we talking windows 2003 or 2008 cluster here?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2010 at 8:00 am
2003 R2 Enterprise Edition (64bit)
October 14, 2010 at 9:03 am
Jpotucek (10/14/2010)
Do you think I should only take the Cluster Group offline
No that would disable access to the cluster! This group will go offline when the last cluster node shuts down.
Jpotucek (10/14/2010)
or should the the Disk Group and MSDTC group also be taken offline?
disk group, what does this mean?
When you created the clustered SQL Server instance the resource group was assigned disk, network name and ip resources. Taking this group offline will stop the sql server instance. it will not restart until you online the group.
Jpotucek (10/14/2010)
We have an Active\Passive cluster running and we have the need to clone it. (the Cluster lives at a hosting company)
Do you have a clone of the other machines in the equation such as DNS server, domain controller, etc?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2010 at 9:11 am
I beleive that their are already exact copies of all of the other Server in the mix.. DNS, Domain Controllers, etc.. The last peice is to get our Clustered SQL Server boxes and our clustered UDB on Linux boxes cloned and moved over.
October 14, 2010 at 9:30 am
Jpotucek (10/13/2010)
What I want to do is bring SQL Server down while they do the actual server backups
Take all SQL Server resource groups offline, this will offline all the disks, names, IP, etc contained in these groups (one for each clustered instance).
Shut down the passive node.
Shutdown the active node.
ghost or clone the servers.
restart the original nodes
Jpotucek (10/13/2010)
and have it still be down after they restore them to the new Servers until we are sure that the SAN drives are done replicating.What is the best way to do this?
Don't boot the clones until replication has completed!!!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2010 at 11:19 am
Thank you : )
Viewing 11 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply