Categories
High Availability

Comparison between Mirroring VS Log shipping and Mirroring VS Clustering

Database Mirroring Vs Clustering

Categories
High Availability

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

Categories
High Availability

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.

Categories
High Availability

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.

Categories
High Availability

Role Change in SQL 2005 Log Shipping

In SQL 2000 where the role change was relatively easy through the use of stored procedures, unfortunately in SQL 2005 those SPs are no longer used and we have to perform the following steps to sync the secondary server with primary and then failover.