Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What is better log shipping or mirroring?

user-image
Question ajoutée par Shahid Khan , SQL Server Production DBA , Acenden Mortgage Solutions
Date de publication: 2014/05/05
rabih karam
par rabih karam , Senior Software Engineer- Analyst And Database Administrator , FPnetWorth

This is a general question where i can answer with "both are usable and important".

But to choose which approach to use it depends on your situation.

If you require only a single destination DB mirroring is recommended.

If you require more than one destination DB you need to use log shipping either alone or with mirroring.

Mohammed Owais
par Mohammed Owais , Director of Technology , Hiring Solutions (Almasa Business Solutions)

Rabih is right, it depends on your situation, they are both there for a reason. In addition to number of nodes you want to support, there is also a question of latency. Database Mirroring can be configured to sync in realtime, but with Log Shipping you will have a little bit of delay, even with the tightest settings.

 

Important: Database Mirroring has been deprecated and will be removed in the next version of SQL Server. Instead, Microsoft recommends using High Availability. HA works similarly to mirroring and the latest version (SQL Server2014) adds several new features to the area. Log Shipping continues to be supported.

More Questions Like This