Database Mirroring

Database Mirroring Automating Failover for Multiple Databases

Database Mirroring was released with SQL Server 2005 and is becoming a popular choice for a failover solution. One of the big issues with Database Mirroring is that the failover is tied to one database, so if there is a database failure the mirrored server takes over for this one database, but all other databases remain functional on the primary server.

Database Mirroring DMV

Database Mirroring

Best Practices when performing maintenance in a DBM environment

If you have configured database mirroring in synchronous with or without automatic failover mode, you can switch to the mirror server instance and make it available to the clients while you perform hardware or software maintenance on the principal server instance. So let’s see how we can do this:

Internals of DBM Failover / Role Switching

Understanding different types of failovers/Role Switching and How do they internally work in database mirroring.

Getting Started with Database Mirroring

If your database goes offline, you’re probably up a creek, right? If you’re using SQL Server 2005 with SP1, however, the database mirroring feature can prevent disaster.