I'm looking for help in locating a script that would allow deliberately
causing a cluster to failover. (For demonstration and testing purposes.)

And ideas or suggestions would be appreciated.

Thanks,

Arnie Rowland

You can use the CLUSTER.EXE command from the command line prompt to force a
failure. Look up Cluster.exe in the on-line help files for Windows Server.
Everything you can do from the GUI, you can do from the command-line.
Example:

Cluster MyClusterName resource MYSQLCluster Resource /fail

Will cause the specific resource to fail. You can then watch how the
cluster reacts.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Arnie Rowland" <arnie (AT) 1568 (DOT) com> wrote

Thanks Geoff,

I forget that it was also command line! Du-oh...

-Arnie


"Geoff N. Hiten" <SQLCraftsman (AT) gmail (DOT) com> wrote

That's OK. I goofed up the example and put RESOURCE in there twice. I
should know better than to answer posts right after lunch.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Arnie Rowland" <arnie (AT) 1568 (DOT) com> wrote

Yeah, I caught that part. ;-)


"Geoff N. Hiten" <SQLCraftsman (AT) gmail (DOT) com> wrote