Tag: Log shipping

SQL Server – Database mirroring vs Log Shipping

SQL, SQL-Advanced, SQL-Tips and Tricks, Varinder Sandhu

I would like to start this topic with very common question for database administrators. Question: What is difference between the Database Mirroring and Log Shipping? Which is preferable solution? Database Mirroring: Database mirroring is functionality in the SQL Server engine that reads from the transaction log and copies transactions from the principal server instance to the mirror server instance.  Database mirroring can operate synchronously or asynchronously. Database mirroring supports only one mirror for each principal database. Database mirroring also supports

» Read more
, ,

SQL Server – Log shipping for Disaster Recovery Solution

SQL, SQL-Advanced, Varinder Sandhu

What is Log Shipping? Log Shipping is a basic level SQL Server high-availability technology. It is automated process to send the transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances. The transaction log backups are applied to each of the secondary databases individually. How Log Shipping working? Log shipping involves copying a database backup and subsequent transaction log backups from the primary server and restoring the

» Read more
, ,