Dave Lumley presents a Reporting services disaster recovery solution for SQL Server Standard Edition, using 2 servers. Worth the read if you don't run Enterprise.  Read more...

Transaction Replication Publisher failover/failback to mirror standby with automatic redirection of the subscriber and client application.  Read more...

Be carefull when replacing a defective (FLASH) storage device, its sector sizes may vary without you knowing it.  Read more...

This tip outlines a test environment and then walks through the process of setting up Database Mirroring. This includes the configurations, backups, restores and verification process.  Read more...

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

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

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

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

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

One thing I have gotten wrong before, or not elaborated on before in presentations on mirroring, although Roman Rehak mentioned...  Read more...

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

Explanation of how to repair a database in SQL 2005 Enterprise which is mirrored.  Read more...

Dave Lumley presents a Reporting services disaster recovery solution for SQL Server Standard Edition, using 2 servers. Worth the read if you don't run Enterprise.  Read more...

Should we evolve the database mirroring technology to work with multiple mirrors? Steve Jones says this might be an interesting idea.  Read more...

Part three of this series illustrates how to use a T-SQL script to create database mirroring between a principal and mirrored server.  Read more...

How to move databases from one server to another with limited downtime  Read more...

Learn the basics of the Database mirroring in SQL Server 2008. Mak provides a step-by-step on how to create database mirroring. Subsequent installments will discuss how to add data on the principal server and how data is mirrored to the mirrored server.  Read more...

Question: What mechanism allows SQL Server 2008 to commit transactions on the mirror faster than SQL Server 2005? This question was asked on a technical discussion group. My reply follows.  Read more...

If you don't have a witness server and your principal server goes, how do you make your mirror server the principal and bring all your databases online?  Read more...

Question: Why is my mirror database in a restoring state? Hi, I am still working on DB mirroring with prinicpal and mirror. There will be no Witness. This is what I did and   Read more...