Hi All, I am deciding on high-availibitly for my database server box. My website can get large number of user hits for 4 days in every quater of year. We are also planning to launch some schemes which will help keep are business and servers busy . I am planning to have 2 node cluster. With configuration Windows Server 2003 Standard Edition 64 bit SQL Server 2005 Standard Edition 64 bit 4 GB RAM 8 x 300 GB Ultra 320 SCSI Hard Drives Hardware RAID 0+1 Redundant Controllers Fiber Attached My Question are. 1) What type of clustering I should go for? (Active/active vs Active/Clustering) and why? 2) Will active/active means load balancing as there will be 2 servers as active and both of them can share the load? 3) What are the advantages and disadvantages of clustering type you recommend in question 1. 4) We are also planning to configure transactional replication on these servers as per disaster recovery plan. Will it an overhead to the servers if they are in different geographical locations? (My network bandwidth is 100 mbps connection) Please help. Thanks in advance. regards S
Usually it also depends if you are planning for 5000 trans/sec for VLDB , then probably you may go for active/active which does load balancing. But I would suggest some reviews of the case studies on VLDB on microsoft site since I have not managed data center yet. http://www.microsoft.com/sql/prodinfo/previousversions/scalability.mspx Regards Sat
Do you really need to go with CLUSTER? As you are using SQL 2005 why not with other high availability options such as DATABASE MIRRORING in this case. Just a thought!
