MSSQL Log Shipping

In log shipping, the database transaction log from one SQL Server is backed up and restored onto a secondary SQL Server, where it is often deployed for high-availability, reporting, and disaster-recovery scenarios. Beginning with SQL Server 2005, log shipping has been enhanced to continue to deliver business continuity and to be one of the high-availability solutions to maintain a warm standby. Using log shipping, the secondary server will be the warm standby used for failover.

Leave a Reply

Your email address will not be published. Required fields are marked *