How to failover automatically in windows server 2k8 failover cluster env.
use the following command:
in 2 nodes env:
Cluster.exe /Cluster:clustername group "SQL Server (MSSQLSERVER)" /move
in more than 2 nodes env:
Cluster.exe /Cluster:clustername group "SQL Server (MSSQLSERVER)" /moveto:node3
Hope it helps.