ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

What is better log shipping or mirroring?

user-image
تم إضافة السؤال من قبل Shahid Khan , SQL Server Production DBA , Acenden Mortgage Solutions
تاريخ النشر: 2014/05/05
rabih karam
من قبل 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
من قبل 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.

المزيد من الأسئلة المماثلة