SQL Server Database mirroring modes and patner timeout

The Two modes of Database Mirroring in SQL Server for HA/DR Solutions are Synchronous mirroring( High Availability / HA ) Asynchronous mirroring( Disaster Recovery / DR ) Synchronous mirroring : In all SQL Server databases, data changes are recorded in the transaction log before any changes to actual data pages are made. The transaction log records…