Tag Archives: Database Mirroring

SQL Server Database Mirroring Tips and Tricks, Part 3

One of the challenges you face with SQL Server database mirroring is making sure that all of the databases that are dependent on each other will failover together, so they are running on the same side of the database mirroring … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Tagged | 12 Comments

SQL Server Database Mirroring Tips and Tricks, Part 2

If you ever find yourself having to setup database mirroring between different, untrusted Windows Domains, one of the most common ways to do it involves creating certificates on each instance, creating logins and users for those certificates, and copying the … Continue reading

Posted in Microsoft, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Tagged | 1 Comment

SQL Server Database Mirroring Tips and Tricks, Part 1

Even though SQL Server Database Mirroring is deprecated in SQL Server 2012, it is still a very useful HA/DR technique that should work perfectly well for at least two-three major versions of SQL Server after the newly released SQL Server … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Tagged | 7 Comments

SQL Server Database Mirroring (Not Dead Yet)

SQL Server Database Mirroring is a high availability and disaster recovery feature that was added to the product with SQL Server 2005, and enabled without a trace flag in SQL Server 2005 SP1. It was enhanced in SQL Server 2008 … Continue reading

Posted in Microsoft, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Tagged | 6 Comments

Database Mirroring From SQL Server 2005 to SQL Server 2008 R2 SP1 CU3

I recently ran into a production instance of SQL Server 2005 SP2 (Build 3042) that is running in a two node, single instance fail-over cluster, running on Windows Server 2003 R2 SP2. As you may be aware, this entire stack … Continue reading

Posted in Microsoft, SQL Server 2005, SQL Server 2008 R2, Windows Server 2008 R2 | Tagged | 9 Comments