SQL Server Performance

Clustering/mirroring writable databases

Discussion in 'SQL Server Clustering' started by spireite, Sep 12, 2005.

  1. spireite New Member

    I'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,
    Paul
  2. satya Moderator

Share This Page