Mirror, Mirror on the Database Microsoft has introduced a new failover technology in SQL 2005, known as Database Mirroring. Database Mirroring has been included in the RTM release of SQL Server 2005 ...

Without using any special hardware, it allows you to duplicate (real time mirroring) a production database on another SQL Server at a different location. In addition, if the first server should become ...

Database Mirroring has automatic failover when you provide a third Witness server and Clients automatically redirect themselves during a failover using the failover_partner setting in the connection ...

This requires three SQL Server instances to play the roles of Principal, Mirror and Witness. The Principal hosts the updateable principal database, the Mirror hosts the synchronized mirror database ...