It’s been quite some time that I blog, Sorry about that I was busy with my movement from USA to India and changed my job part of life ,okay back to India (Pune).

Lastly I wrote a blog on High Availability techniques here and How to setup simple Mirroring Here. Continue on that following are some of the common difference of log shipping and Mirroring, actually both uses log and move the transaction “Mirroring used to call Real time Log shipping”. but the way it works makes it difference.

Mirroring

Log Shipping

Principle can have single mirror

Multiple stand by servers can be possible.

generally good to have 10 DB’s for one server

No limit

No data loss and can be used as high availability like Clustering

May be some data loss as per schedule. And secondary server takes some manual work and time to be primary

Read log read and transfer the committed transaction through endpoints.