I have an application (developed using VB.net) that use MS SQL Server 2005 as the DBMS. One of the requirement is we have to ensure high availability of SQL Server. When one of the node is down, the secondary node should take over the role automatically. In addition, both of the database reside in different node should sychronize in real-time basics so that the data that i retrieve from the active node is the same. I think my application just have to connect to the virtual server whereby i do not care which node is active. How can i take advantage from feature of MS SQL Server 2005 to satisfy this requirement? Can anyone provide me a most cost effective solution to implement it? which edition of MS SQL Server 2005 and OS?
Any help is appreciated. Thanks a lot.