Hcltouch Number for Noida - 18601800425
For Desktop - Monday to Saturday 9:00 AM to 5:00 PM
For Labtop - 24x7
| 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. |