Failback SQL instance on right node after Failover
Posted on 2012-08-23
I have a 2 node SQL server 2008 cluster.
When the failover occurs ,both instances run on same node which is OK. I have to then manually move the services from failover node to the original node. We have heavy processing over night /weekends and running everything on one node is a problem.
I have seen a way to automate it so that once node which had issues is up and running, the SQL instance can fail it back at original node.
Is this risky? Is there any way to carry a node sanity check before carrying automatic failback?