SQL Server Performance

active/active mssql setup

Discussion in 'SQL Server Clustering' started by v1rtu0s1ty, Nov 2, 2004.

  1. v1rtu0s1ty New Member

    Hey guys,

    Is it possible to convert our existing active/passive Cluster MSSQL setup to active/active configuration? If so, how is it? Are there docs that you can send please?


  2. satya Moderator

    Refer to the articles in SQL Server 2000 Books Online. The latest version of SQL Server 2000 Books Online can be downloaded from the following linkhttp://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

    - How to upgrade from a SQL Server 7.0 active/passive failover cluster (Setup)
    - How to upgrade from a SQL Server 7.0 active/active failover cluster (Setup)
    - How to upgrade from a default instance to a default clustered instance of
    - SQL Server 2000 (SQL Server Setup).

    You must install the binaries to a local drive and use a cluster disk for the data. This local drive is a path, which is a non-clustered disk valid on all nodes of the cluster.

    (moved from General DBA section)

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. Med New Member

    Just intall another instance of SQL Server and make the other node its preferred node.
    In SQL Server 2000, It's nothing more than that !!!
    In previous versions, it was a real nightmare

Share This Page