SQL Server Performance Forum – Threads Archive
Clustering/mirroring writable databasesI’ve looked at white papers and I’m not really getting to grips with certain things – in fact what I want doesn’t look possible! Presently we have one SQL backend server. We want to add another. These will be identical in every way with identical databases. We want both to be available (load balancing), and if data is written to 1, we want that write mirrored to the other. What we don’t want is a failover (so I’ve been told). So, how do we achieve that? Is it possible? Many thx,
Database mirroring is possible only from SQL 2005 and for SQL 2000 refer thishttp://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/spltmirr.mspx link and Failover Clustering in SQL 2000 also helps what you want to achieve. Refer to the Clustering articles in this website for more inforamtion. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.