Jan 15, 2010

Database Mirroring Vs Database Replication [SQL 2005 and Above]


Database Mirroring

Database Replication

Making the same database with transaction logs [ synchronous or asynchronous]

Making the same database replicated on other server.

Only snapshot can be used to fetch the data from mirroring server.

Can be fetched data directly from the replicated server.

Mirroring is preferred when we want database online most of the time.

Replication used when we need to run the reports without affecting the primary database performance.

In case of failover the mirroring database in as primary database.

In case of failover you have to specify the secondary database name, it's not failover automatically.


0 comments:

Post a Comment