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… Continue reading Log shipping – Sql2005
Tag: log shipping
Comparison between Mirroring VS Log shipping and Mirroring VS Clustering
Database Mirroring Vs Clustering
Ten Steps to configure Log Shipping
I have used 3 instances to configure log shipping and they are as follows, Deepak—>Primary DeepakSansu—>Secondary DeepakTest—>Monitor
Failover in SQL 2005 Log Shipping
The most important aspect in Log Shipping is Failover. Lets discuss it detail ! ! ! If the primary server in Log Shipping becomes unavailable or if it is going to be down due to some manual intervention, DBA should immediately perform the following steps for failover.
Prerequisites for Log Shipping
The following are the prerequisites to configure Log Shipping SQL 2005 1. SQL Server 2005 Enterprise Edition, SQL Server 2005 Workgroup Edition, or SQL Server 2005 Standard Edition must be installed on all server instances involved in log shipping. 2. The servers involved in log shipping should have the same case sensitivity settings.