| 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. |
Jan 15, 2010
Database Mirroring Vs Database Replication [SQL 2005 and Above]
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment