Re: Demonstration of Failover Capabilities

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




"vihrea" <vihrea@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B1CC5D49-49EB-48C4-A5A9-42068E906C20@xxxxxxxxxxxxxxxx
Care to say anymore about that Mr SQL MVP? Source code didn't jump out at
me
as I visited your site...

AMF
-vihrea

"Rodney R. Fournier [MVP]" wrote:

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


"vihrea" <vihrea@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F09FF983-E9CD-4425-B98C-7F03D9A6B7A9@xxxxxxxxxxxxxxxx
I'd like to find a program that clearly demonstrates how SQL 2005
failover
works
(flawlessly). This application would be used to show that a failure can
occur and users are not impacted by that failure.

This program would:

1) execute a datareader to page through a query displaying its data .
2) display the source server e.g., failover1 or failover2
3) have a button to reboot either of the two server

I could write an app to perform these functions but it if someone know
of
an
existing one, would you forward a link along

Thanks
-vihrea






.