[noname]

Hello all,

My experience is limited to the use of the Enterprise Manager and hence need to consult the experts here what are the correct steps to manually failover one SQL server to another using the Cluster Admin client. I need to know as I will be restarting SQL servers one by one for a maintenance window and I wanna make sure my BES servers are failed over to the other SQL server in the SQL Cluster.

E.g. SQLCluster
{
SQLServer1
SQLServer2
}

Any advices? Thanks!

[noname]

None of you guys here use SQL Clustering?

[noname]

Finally managed to find the answers from a good old buddy. Sharing the various methods for manual failover:-

How to Cluster SQL Server 2005