Search:
Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in SQL Server Mirroring

Interview Question :: What is difference between database Mirroring and Replication

A have SQL Server 2005 enterprise edition. What is difference between database Mirroring and Replication? and in which situation the one is better then other?

Answers to "What is difference between database Mirroring and Replication"

RE: What is difference between database Mirroring and Replication?
The terms replication and remote mirroring are frequently used interchangeably because their meanings are very similar. Replication is the process of duplicating primary data volumes over an IP connection to a storage subsystem at an alternate location. This redundant copy can then be used by business applications if access to the primary data is interrupted. The source and target of a replication are usually separated by a significant distance to safeguard data from disasters that effect a specific geographic location, such as a region-wide power outage. Replication techniques have two principle modes: asynchronous and synchronous. With asynchronous replication, the primary and secondary data volumes are no more than a few milliseconds out of sync, so the replication is nearly real-time. With synchronous replication, the primary and secondary copies are always identical, so it provides a true real-time duplication. (See Replication.) Like replication, remote mirroring uses redundancy to guarantee data availability. A remote mirrored data volume consists of two identical copies of the data connected by Fibre Channel. Both sides of a mirror process read and write I/Os to ensure each copy is a real-time duplicate of the other. The mirror copies are housed in separate data centers, connected over a local- or metro-area network (LAN or MAN). If a disaster interrupts access to one side of a mirror, the surviving copy will continue to service application I/O requests and therefore minimize the disruption to business users. ...verbatim from veritas.com website
Vote for this answer ::

RE: What is difference between database Mirroring and Replication

1. In Replication we can do object level copying where Mirroring is databse level.

2. There is no automatic fail over in Replication where as in Mirroring it is possible

3. We can maintain as many as subscription server in Replication in Mirroring there is only one primary server and one Mirror.

Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Top Tags

- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers

Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in SQL Server Mirroring

Interview Question :: What is difference between database Mirroring and Replication

Top Tags