Category: 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
-
Types and Operating Modes in Mirroring
Mirroring offers two methods for exchanging data, lets discuss each one in detail.The two are * Synchronous mirroring * Asynchronous mirroring
-
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.
-
How can I bring mirror database online after principal server is down ?
Safety FULL with Witness : Well the answer for this ‘depends on the mode in which mirroring is configured’. If mirroring is configured in High Availability mode (Full safety) then we don’t need to worry about failover as the mirror server will form a quorum with witness and will initiate an automatic failover. The safety…
-
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.