SQL Server Transaction Log Shipping vs Mirroring – A Comprehensive Guide


SQL Server Transaction Logs record the entire information about the transactions and data modifications made by the transactions in the server. In order to create backup or ensure the availability of transaction logs at the instance of any disaster, SQL offers two processes- SQL Log Shipping and SQL Log Mirroring.

In this section, we will describe both these processes and the parameters in which they differ from each other. Continue reading “SQL Server Transaction Log Shipping vs Mirroring – A Comprehensive Guide”