mibuso.com
Home› SQL General
Options

SQL server 2005 mirroring in high availability mode

davmac1davmac1 Member Posts: 1,283
edited 2011-03-16 in SQL General
One of our clients wants to run SQL server 2005 mirroring in high availability mode (auto failover).
My understanding is that high availability may not provide 100% duplication.

Will this work for them or should they rather do log shipping?

Navision version is 2009, though they may be on SP1 by the time they do this.
David Machanick
http://mibuso.com/blogs/davidmachanick/

Comments

  • Options
    bbrownbbrown Member Posts: 3,268
    We have a cleint that has been running mirroring in high availability mode for about 4 years now. They started in SQL 2005 and are now in SQL 2008. I would dispute the claim of "high availability may not provide 100% duplication" since in high availability mode, transactions are committed to both or neither server.
    There are no bugs - only undocumented features.
  • Options
    davmac1davmac1 Member Posts: 1,283
    Thanks.
    it is always good to hear about successful real life examples.
    David Machanick
    http://mibuso.com/blogs/davidmachanick/
Sign In or Register to comment.