Register now or log in to join your professional community.
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.
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.
