| 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)
-
Clustered Index | Non Clustered Index Indexing is used to get fast retrival of data. The indexing which is done on physical storage is known...
-
All about Haj, please visit http://www.hajcommittee.com This year UP haj pilgrims will be decided on lottery draw due to more responces of l...
-
To get all the triggers list and their scripts run the script below. View the result in file view mode. SELECT [text] FROM sysobjects o ...
No comments:
Post a Comment