Log shipping – Sql2005

Log shipping allows you to automatically send transaction log backups from one database (known as the primary database) to a secondary database on another server (known as the secondary server). At the secondary server, these transaction log backups are restored to the secondary database, keeping it closely synchronized with the primary database. An optional third server, known as the monitor server, records the history and status of backup and restores operations and optionally raises alerts if these operations fail to occur as scheduled.


The following are the benefits of Log Shipping in SQL 2005

1. High Availability —> Even if primary is down we have the standby server hence it provides high availability of data
2. Cost —> It is the least expensive as it is available even with Workgroup edition
3. Multiple Secondary —> This provides higher redundancy of data by providing multiple standby servers.

Related Links:

What is Log Shipping?

Pre-requisites for Log Shipping

10 Steps to configure Log Shipping

Fail-Over in Log Shipping

Role Change in Log Shipping

By Deepak

Microsoft Most Valuable Professional (MVP) award-winning Database Designer with 5 years of experience in designing, administering, developing & performance tuning relational databases and data warehouse. I possess strong leadership skills experience by serving as the Chapter Leader of Professional Association for SQL Server (PASS) which has around 50 members. I am passionate about solving business problems using my technical skills and hence I am interested in the field of Technology Consulting in Information Management.

Leave a Reply

Leave a comment

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