Disaster Recovery

Auto Page Recovery with DB Mirroring

Database Mirroring Setup

This great tutorial shows how to set up database mirroring across two instances in a virtual environment.

Database Mirroring

Changing the default port numbers when configuring database mirroring

There are times when you need to use different network ports to communicate between two servers running database mirroring. Learn how to change the default ports.

Using Disparate File Paths in SQL Server Database Mirroring

Learn how you can setup Database Mirroring using disparate file paths and drive letters.

Database Mirroring Performance Monitoring

Many people deploy performance monitoring solutions in a "one-size-fits-all" manner. That is, they tend to build a solution that can be easily deployed to multiple servers and capture basic information from each server. The trouble is that not every server is identical, not even within the same shop. For example, not every server may have database mirroring deployed, which means your performance monitoring solution may be missing some critical pieces of information with regards to monitoring database mirroring.

Configuring Database Mirroring

This article contains a set of instructions for configuring SQL Server mirroring, including pre-requisites. It also includes notes on how to resolve a few issues that I have encountered.

Convert Mirroring to Log Shipping

Describes how to convert database mirroring to log shipping in SQL 2005/2008.

Mirroring & Filestream in SQL 2008