I have a four processor box running Microsoft virtual server 2005. I need to set up four Windows server 2003 - SQL server 2000 virtual machines on this box. Three of these virtual machines I need to cluster in an Active - Active - Pssive scheme. (The passive box will take over for either failed machine.) My goal is to use this environement as a production image on which to conduct systems testing for migration to SQL Server 2005.
I am finding several articles on implementing active - passive clustering in a virtual environment; but nothing on active - active - passive. Also - my systems engineer believes that only 2 node clustering is supported in VM. I have not seen that from Microsoft and do not believe it to be true. But nor have I found it from Microsoft that it can be done.
Does anyone have any ideas on this?? Can you point me to literature on how to set it up??
Thanks. Much appreciated.