Database Mirroring Archives - Brent Ozar Unlimited®

Asynchronous Database Mirroring vs. Asynchronous Availability Groups

September 20, 2016

When Database Mirroring came out in SQL Server 2005 Service Pack 1, we quickly dropped Log Shipping as our Disaster Recovery solution. Log Shipping is a good feature, but I can failover with Asynchronous Database Mirroring faster than I can with Log Shipping.

When Always On Availability Groups (AG) came out in SQL Server 2012, we were excited to get rid of Transactional Replication, Failover Clustering and Database Mirroring. It solved our reporting needs (your mileage may vary), our High Availability needs and our Disaster Recovery needs.

A funny thing happened on my way to set up Mirroring…

February 2, 2016

I've set up Mirroring about a billion times I'm not bragging about that. I'd rather say that I set up a billion AGs, and not one of them ever failed. But then I'd be lying to you; those things fail like government programs. One thing I'd never done, though, is set up Mirroring with a…

Failing over an Asynchronous Mirror in SQL Server (video)

February 2, 2015

Will a long running open transaction block you from changing to synchronous mode and failing over to your SQL Server database mirror? Join Kendra to test performing a planned failover from an asynchronous database mirror.

http://youtu.be/5rAr2Gns1mU

What Amazon RDS for SQL Server Users Need to Know about Multi-AZ Mirroring

May 28, 2014

Amazon Relational Database Service (RDS) now supports multi-availability-zone SQL Servers. This means you can have a primary database in one data center, and a secondary replica in another data center.

When your primary server goes down, OR when the entire AZ goes down, you can fail over to the secondary with zero data loss and keep right on going. When the primary comes back online, you can fail right back, again with no data loss.