Database Mirroring Best Practices
Database Mirroring Best Practices and Performance Considerations ... Source : Microsoft.com - Technet Article
Automatic Page Repair with Database Mirroring
One of the hottest features in SQL Server 2005 is database mirroring, and it's helped many companies implement successful and relatively inexpensive high-availability strategies. In SQL Server 2008, Database Mirroring has been enhanced in several ways - one of which is the ability to automatically repair corrupt pages! ... Source : Paul Randall - SQLskills.com - Blog Post
Performance Boost for Database Mirroring
In this blog post, Paul talks about how the Log Stream Compression feature in 2008 may boost the performance of synchronously mirrored databases where network throughput is constrained by large transaction rates ... Source : Paul Randall - SQLskills.com - Blog Post
Database Mirroring FAQ
Common questions surrounding Database Mirroring features and requirements ... Source : Microsoft.com - Technet Article
Can defragging an index break synchronous mirroring ?
In this post, Paul talks about some of the situations in which a synchronous mirror may enter the "Synchronizing" status ... Source : Paul Randall - SQLskills.com - Blog Post
Implementing Application Failover with Database Mirroring
Database mirroring allows a database to fail over from one server to another. For a seamless user experience, it is important that the application automatically reconnect to the current principal server. This paper describes how to enable your application to automatically fail over when database mirroring failover occurs ... Source : Microsoft.com - Technet Article
Minimize downtime during planned outages with DB Mirroring
In this post, Kevin Cox and Glenn Berry share a DB Mirroring technique they used to minimize downtime during a planned outage. Also known as a rolling upgrade, this technique is also explained in this BOL entry ... Source : SQL CAT Team - Blog Post
Database Mirroring
A comprehensive overview of Database Mirroring in SQL Server 2005 ... Source : Microsoft.com - Technet Article
Database Mirroring Event Alerts
This document describes the database mirroring events that SQL Server generates and how to configure alerts on these events using SQL Server Agent. Two sample scripts are also provided to demonstrate these concepts ... Source : Microsoft.com - Technet Article
Login Failures after a Mirroring Failover
One of the crucial aspects of a successful database mirroring installation is ensuring logins work at both ends (principal and mirror). As Chad points out, the SIDs for SQL Server logins need to match to ensure a smooth failover process ... Source : Chad Boyd - MSDN.com - Blog Post
Combining Database Mirroring and Log Shipping in SQL Server 2005
This topic discusses considerations for combining log shipping and database mirroring ... Source : Microsoft.com - MSDN Article
Database Mirroring and Log Shipping Working Together
Log shipping and database mirroring can work together to provide solutions for high availability and disaster recovery. You can convert an existing log shipping configuration to a database mirroring configuration. Although Microsoft only supports a single mirror database, you can set up log shipping from a database mirroring pair to additional servers, to provide multiple failover sites. Moreover, you can easily switch which pair of instances is using database mirroring and which instances are configured with log shipping ... Source : Microsoft.com - Whitepaper