I have a query regarding using a cluster of MS SQL 2005 servers in both HA and load balancing mode using native technologies of microsoft. I had come to know that using Microsoft Cluster services (MSCS) and NLB on physical servers, the above can be achieved.
I currently have a a cluster using MSCS on Windows 2003 Ent. servers configured to provide Active/Passive configuration of SQL. I need to covert this into n+1 failover/load balancing mechanism where both my nodes as of now, can be used in Active mode and when budget permits I will bring in the third server to the cluster to act as a standby.
How do I achieve this without losing the data that currently resides on my A/P SQL cluster?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.