SQL Server Database Mirroring

Database mirroring is a Microsoft recommended solution for increasing the availability and data protection of a SQL Server (MSSQL) database. It transfers transaction log records directly from the principal server to the mirror and can automatically fail over to the latter in high safety mode without data loss. You can also code client applications to redirect their connection information. Moreover, different from the traditional failover involved high hardware cost and great software complexity, database mirroring does not require proprietary hardware, and is easier to set up and manage.