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. RonneilRefer 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.
HTH
(moved from General DBA section) Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
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
]]>