Re: Clustering SQL 2000

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Gianluca Hotz (ghotz_at_alphasys.it)
Date: 02/18/04


Date: Wed, 18 Feb 2004 13:41:29 +0100

Hello, Olutimi!
You wrote on Wed, 18 Feb 2004 03:13:37 -0800:

O> I have a two-node SQL2k active/passive failover cluster
O> on WIN2k ADV SP3.

O> I would like to install a new instance of SQL2k for
O> another application in the failover cluster.
O> Please advice.

Exactly in which are you need advices ?

You can setup the new instance by simply using SQL Server
setup, the new instance can then be assigned to either
nodes.

Be sure to evaluate rigorously how memory and CPU resources
will be split among the two instances otherwise when a node
fails, and both instances are running on the same machine,
service availability may be discontinuous due to resource
drainage.

HTH

--
Gianluca Hotz - SQL Server MVP
http://italy.mvps.org - http://www.ghotz.com
http://www.ugiss.org  - http://www.ugidotnet.org


Relevant Pages

  • RE: URGENT: evciting cluster node
    ... BEFORE evicting the primary node, run SQL Server setup on the secondary node and remove the primary node from SQL Failover cluster. ...
    (microsoft.public.sqlserver.clustering)
  • RE: Need help with proper cluster node uninstall...help needed!!
    ... You will need to remove the node from the existing SQL Server 2000 virtual Failover Cluster by following these steps: ... Run SQL Server 2000 EE Setup on the node where SQL Server is currently running. ... On the Welcome screen of the Microsoft SQL Server Installation Wizard, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cant get SQL 2000 installed on new node in Cluster
    ... How to remove a node from an existing failover cluster (Setup) ... On the Welcome screen of the Microsoft SQL Server Installation Wizard, ...
    (microsoft.public.sqlserver.clustering)
  • RE: Cluster Resource Dependencies
    ... SQL Server 2005 Failover Clustering White Paper ... Installing a SQL Server 2008 Failover Cluster ... A mounted volume, or mount point, allows you to use a single drive letter ... to refer to many disks or volumes. ...
    (microsoft.public.sqlserver.setup)
  • RE: Installing an sql server 2008 cluster on server 2008 from scratch
    ... when using the Advanced Cluster Preparation settings are ... On the installation screen we have two options ... New SQL SERVER failover cluster installation. ...
    (microsoft.public.sqlserver.clustering)