Groups | Blog | Home
all groups > sql server clustering > march 2005 >

sql server clustering : .NET /script/T-SQL Code to deliberately cause Cluster Failover


Arnie Rowland
3/1/2005 10:31:15 AM
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


Arnie Rowland
3/1/2005 11:07:42 AM
Thanks Geoff,

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

-Arnie


[quoted text, click to view]

Arnie Rowland
3/1/2005 11:26:56 AM
Yeah, I caught that part. ;-)


[quoted text, click to view]

Geoff N. Hiten
3/1/2005 2:04:29 PM
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

[quoted text, click to view]

Geoff N. Hiten
3/1/2005 2:11:16 PM
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

[quoted text, click to view]

AddThis Social Bookmark Button