DRaS Specifications

MSSQL Replication (Database Mirroring Feature)

1. The Replication Solution proposed herewith is by using the inbuilt features of Microsoft Tools/ Utility to get the desired results and achieve the goal of maximum uptime.

2. The following table lists SQL Server availability options and their ability to meet various Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO).

Technology	Granularity	RPO – Data Loss	RTO - Downtime
Replication	Publication	Some	Variable
Database Mirroring (1)	Server, Database	No	< 3 sec
Database Mirroring (2)	Database	No	< 3 sec
Database Mirroring (3)	Database	Some	< 3 sec
Log Shipping	Database	Possible Transaction Log	Variable

High Safety mode with Automatic Failover.
High Protection Configuration.
High Performance Configuration.

3. Considering No RPO and less RTO, it has been proposed to use Mirroring feature.

4. Replication of databases (or file systems) is done simultaneously i.e. there is no delay experienced by users while the data is being replicated.

5. Asynchronous Replication has the advantage of speed, at the increased risk of data loss during due to communication or duplicate system failure.