SQL server 2005 mirroring in high availability mode

davmac1

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.

bbrown

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.

davmac1

Thanks.
it is always good to hear about successful real life examples.