 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Clustering / August 2006Demonstration of Failover Capabilities
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 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 > I'd like to find a program that clearly demonstrates how SQL 2005 failover > works [quoted text clipped - 13 lines] > Thanks > -vihrea Care to say anymore about that Mr SQL MVP? Source code didn't jump out at me as I visited your site... AMF -vihrea > You have a just described a test cluster built by a SQL MVP :) > [quoted text clipped - 25 lines] > > Thanks > > -vihrea 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  SignatureGeoff N. Hiten Senior Database Administrator Microsoft SQL Server MVP > Care to say anymore about that Mr SQL MVP? Source code didn't jump out at > me [quoted text clipped - 34 lines] >> > Thanks >> > -vihrea 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 > I'd like to find a program that clearly demonstrates how SQL 2005 failover > works [quoted text clipped - 12 lines] > Thanks > -vihrea 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 > I'd like to find a program that clearly demonstrates how SQL 2005 failover > works [quoted text clipped - 12 lines] > Thanks > -vihrea |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.