Database Mirroring Using T-SQL

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

Ten steps to migrate databases between servers in a .Net environment

How to move databases from one server to another with limited downtime

Database Mirroring Limit

Database Mirroring in SQL Server 2008

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.

Accessing Mirrored Data

Database Mirroring

Database Mirroring

Database Mirroring Automating Failover for Multiple SQL Server Databases With No Witness

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?

SQL Server 2008 Mirroring Testing

Comparison of performance of SQL 2008 mirroring to SQL 2005 mirroring.

Database Mirroring adjusting the automatic failover time

One of the configuration options for Database Mirroring is the High Availability mode. With this option three servers are put in place the principal, mirror and witness servers. This is the only option that allows for automatic failover. One of the things that I have noticed is that when there are periodic network issues a failover occurs even though there are no issues with the Principal server. Are there any options to delay the failover?