Log Shipping in SQL Server

Question

I want to know what is log shipping in SQL Server. Thank you.

Satyapriya Nayak · Answer

Hi Vipendra, Log shipping technology is one of the methods for implementing High Availability solution. Log shipping is easy to set up, standby database can be available for reporting purpose, easy to maintain and troubleshoot, and multiple standby databases can be configured for log shipping in the same server or instance. One of the main issues or concern with log shipping is adding overhead to the disk subsystem because of frequent transaction log backup. More frequent the transaction log backup taken, the more overhead will be added to the server disk subsystem, and this leads system slow down. In SQL Server, transaction log provides an ability to recover a database to a point in time. Log shipping is a process of copying the transaction log back up from a source server to a destination server and restore on the destination server. The main objective of implementing log shipping is to maintain two SQL Server database synchronized in separate locations for high availability. Basic Components of Log shipping are: 1. Primary server 2. Secondary Server 3. Monitor Server Refer for more http://www.sqlmag.com/article/sql-server-70/log-shipping-with-sql-server-7-0 http://www.codeproject.com/KB/database/LogShipping.aspx Thanks