When SQL Server 2005 is released to manufacturing in the next few months, Microsoft will take the exceptional step of designating one of its high-profile features as being intended for evaluation only ...

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 ...

One surprising aspect of Database Mirroring is that the clients will transparently redirect themselves no matter what mode we are using. The default mode of Database Mirroring is High Availability.

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 ...