Saturday, February 25, 2012

.NET /script/T-SQL Code to deliberately cause Cluster Failover

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@.1568.com> wrote in message
news:uyoFczoHFHA.1528@.TK2MSFTNGP09.phx.gbl...
> 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
>
>
|||Thanks Geoff,
I forget that it was also command line! Du-oh...
-Arnie
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:#7m#$FpHFHA.1172@.TK2MSFTNGP12.phx.gbl...
> 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@.1568.com> wrote in message
> news:uyoFczoHFHA.1528@.TK2MSFTNGP09.phx.gbl...
>
|||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@.1568.com> wrote in message
news:OBwY0HpHFHA.3612@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Thanks Geoff,
> I forget that it was also command line! Du-oh...
> -Arnie
>
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:#7m#$FpHFHA.1172@.TK2MSFTNGP12.phx.gbl...
force[vbcol=seagreen]
> a
> Server.
deliberately[vbcol=seagreen]
purposes.)
>
|||Yeah, I caught that part. ;-)
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:ePtnyJpHFHA.2740@.TK2MSFTNGP12.phx.gbl...
> 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@.1568.com> wrote in message
> news:OBwY0HpHFHA.3612@.TK2MSFTNGP09.phx.gbl...
> force
> deliberately
> purposes.)
>

No comments:

Post a Comment