Virtual SQL Server

From: Olutimi (anonymous_at_discussions.microsoft.com)
Date: 02/24/04 

Date: Tue, 24 Feb 2004 04:07:16 -0800

Can I have another Virtual SQL Server on the existing
Cluster (MS SQL 2000 Cluster)?.
Current configuration is SQL SERVER 2000 EE in an
Active/Passive two-node Cluster Configuration.
For example Cluster Name is CLUST1 and VIRTUAL SQL SERVER
is VS1.

My intention is to have one named instance of SQL Server
in another virtual SQL Server on both nodes. If this is
practicable what are the steps to achieve this and any
downside?.

Regards

Help appreciated.

Relevant Pages

  • RE: Cluster Configurations
    ... is there any advantage of creating a 8-Node cluster in SQL server then? ... I think we decided the 8-node configuration to better use the hardware. ... Named Instance -> Failover to Node 4 ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Now, for the first problem, adding the 3rd node as a member of the cluster. ... You then installed a 2nd instance of SQL Server. ... DBC01 (Disks, SQL Server resources) ... Install RTM SS2K and designate the node membership. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: ACTIVE/ACTIVE configuration
    ... active/active cluster configurations. ... understand that in that configuration each instance ... >I support the Professional Association for SQL Server ... >> logical data source via SAN solution? ...
    (microsoft.public.sqlserver.clustering)
  • Re: active/passive with multiple instances
    ... An Active/Passive cluster is always called that and never Passive/Active. ... There is only 1 SQL Server per instance:) Just so other don't get confused. ... It does matter about the hardware, to achieve true HA it needs to happen at ... a SQL Server DBA plain and simply doesn't care about it being ...
    (microsoft.public.sqlserver.clustering)
Loading