Demonstration of Failover Capabilities -- sql server clustering

vihrea
8/25/2006 11:46:02 AM

Care to say anymore about that Mr SQL MVP? Source code didn't jump out at me
as I visited your site...

AMF
-vihrea

[quoted text, click to view]

Rodney R. Fournier [MVP]
8/25/2006 1:31:25 PM

You have a just described a test cluster built by a SQL MVP :)

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner

[quoted text, click to view]

Geoff N. Hiten
8/25/2006 5:51:41 PM

What Rodney was suggesting was that you build a test SQL cluster and use it
to demonstrate failover. I suggest using Virtual Server as it is much
cheaper than buying physical cluster hardware. IIRC, I saw this
demonstrated at one of the PASS summit presentations last year by a MVP.

Here is a link to a webcast on exactly how to build your a Virtual Server
hosted cluster.
http://support.microsoft.com/kb/891798/en-us

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

[quoted text, click to view]

Linchi Shea
8/25/2006 6:47:02 PM

If you can be content with command line only, you can cobble together a
simple batch file to demo this.

In the batch file, (1) use cluster.exe to control when you want to failover
a SQL instance (i.e. move the corresponding resource group) and try query the
status of the cluster (e.g. which node the instance is running on); (2) use
osql.exe to submit SQL queries, and use (3) shutdown.exe to reboot the nodes.

I personally would prefer a real scripting language to control these pieces.

Linchi

[quoted text, click to view]

vihrea
8/26/2006 4:20:01 PM

Thank You L,

I wasn't clear in my initial request about the fact that I have a cluster up
and running. I rely on scripting a fair amount and will look over your
suggestion. I also played with the SQL 2005 sample app for mirror and it gave
me some ideas about using the sqlncli object (or at least looking in the
framework to find the right objects).

I'm surprised that there isn't an app sitting around at MS for us valued
customers.

-vihrea

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

sql server clustering : Demonstration of Failover Capabilities