Disaster Recovery | Varinder Sandhu

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

SQL Server – Database Mirroring for Disaster-Recovery Solution

Varinder Sandhu SQL, SQL-Advanced, Varinder Sandhu

What is Database Mirroring? Database mirroring is a solution for increasing the availability of a SQL Server database. But it has been gained popularity as a disaster-recovery option. How Database Mirroring Working. The principle server sends the active transaction log record to the mirrored server. The mirrored server applies the

» Read more

Database Mirroring, Disaster Recovery, SQL Server