how to implement the sql server mirroring? RRS feed

  • Question

  • i have two computers with Sql server 2000 std edition(SP4) and windows 2003 std edition(SP1).

    how should i do to balance the loading of sql server and sync these two servers?

    The sql server mirroring means that if one server is down, then the other one will replace it?




    Monday, August 28, 2006 11:59 AM


All replies

  • Database Mirroring is a feature in SQL Server 2005 SP1.
    Monday, August 28, 2006 7:38 PM
  • can i use sql server 2005 to mirror a database of sql server 2000 ? or, both of these two servers must run the 2005.
    Tuesday, August 29, 2006 2:55 AM
  • both the servers must run 2005. By default db mirroring is disabled. You need to enable it using trace flag 1400
    Tuesday, August 29, 2006 4:06 AM