Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 Testing SQL 2005 on a clustered Server

Author  Topic 

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2007-01-04 : 08:37:16
Hi folks
Installing SQL 2005 on a Clustered Server.
This is my first major project.
What I want to know is, is there any publication that would help me test the SQL2005 for high availability.

what I would be doing is as follows:
1. With the apps running, remove the network tap from one of the cluster member servers. Put it back after a while and test during both phases.
2. with the apps running, pull the power chord one of the member servers , but it back after a while and test during both phases.
3. Bring down one member server at a time to apply MS Patches or planned maintenance and bring it up. And of course test it for availability during the time.

Has any body tested it for more cases?
I have a whole week to mess around with it.
Any help will be highly appreciated.
Regards
Paresh Motiwala
   

- Advertisement -