Link to home
Start Free TrialLog in
Avatar of OKE-JP
OKE-JPFlag for Japan

asked on

Reliability of the database mirroring

I am desiring to use the asynchronous database mirroring on SQL Server 2008 or 2012.
But, I heard this feature is not so reliable than the log shipping and I may lose data when putted under the heavy transactions usage.
Is it true?

Currently I am using log shipping on SQL Server 2005 Enterprise Edition.
This log shipping is working fine.
But if when the need comes to handle fail-over to secondary server and recover to primary server,
it is not easy to operate for all our colleagues.
So, I am seeking more easy solution but not clustering and replication.

Please give me advice.
ASKER CERTIFIED SOLUTION
Avatar of Ryan McCauley
Ryan McCauley
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Database Monitoring is a feature avaible from SQL Server 2005, it is a best feature
with failover
Avatar of OKE-JP

ASKER

Thank you, ryanmccauley and sqlservr.<br />Than, I will try to use and evaluate the Database Monitoring.
Avatar of OKE-JP

ASKER

Thank you, ryanmccauley and sqlservr.<br />Than, I will try to use and evaluate the Database Monitoring.
Avatar of OKE-JP

ASKER

Thank you, ryanmccauley and sqlservr.<br />Than, I will try to use and evaluate the Database Monitoring.