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.
-
Introduction to Database Mirroring
Overview of Mirroring: Mirroring is mainly implemented for increasing the database availability. Similar to log shipping mirroring is also implemented on per database basis. Database mirroring maintains two copies of a single database that must reside on different instances of SQL Server Database Engine (server instances). Typically, these server instances reside on computers in different…