active/active mssql setup | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

active/active mssql setup

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? Thanks. Ronneil
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 link – 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.
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