Tag: Disaster Recovery

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
, ,

SQL Server – Database Mirroring for Disaster-Recovery Solution

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 transaction log record one by one in sequence. Prerequisites The two partners, that is the principal server and mirror server, must be running the same edition of SQL Server. The

» Read more
, ,