February 16, 2016 at 2:55 pm
Will moving cluster group from node1 to node2 break anything?
February 17, 2016 at 6:13 am
A movement of a SQL cluster group inside a WFC to another node is basically the same as an automatic failover. The SQL Server will go down on the active node, disconnecting all connections. After the cluster group has moved to the other node the SQL Server will start again and all databases will get back online. This could take some time depending on database size, filestructure, rollback uncommitted transactions, etc. After the restart process is completed the databases are back in the same consistent state as when the SQL Server was stopped.
So during an automatic or manual movement of the cluster group to another node the application will experience downtime of the SQL server.
February 17, 2016 at 10:29 am
muthyala_51 (2/16/2016)
Will moving cluster group from node1 to node2 break anything?
Depends if it's been configured correctly?
Moving a cluster role between nodes should otherwise be trouble free apart from the obvious outage required to move the role
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply