Log shipping | Varinder Sandhu

SQL Server – Database mirroring vs Log Shipping

Varinder Sandhu 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

» Read more

Database Mirroring, Log shipping, SQL Server

SQL Server – Log shipping for Disaster Recovery Solution

Varinder Sandhu 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

» Read more

Disaster Recovery, Log shipping, SQL Server