Database Mirroring in Sql Server
A Little Bit about Database Mirroring
Database Mirroring is a software solution for increasing database availability.
Database mirroring offers a substantial improvement in availability over the level previously possible using Microsoft SQL Server and provides an easy-to-manage alternative or supplement to failover clustering or log shipping.
However, it is only supported with SQL Server 2005 SP1. If you are using SQL 2005 without SP1, you should not implement database mirroring on a production server (https://support.microsoft.com/?kbid=907741).
Although, there is a lot of information on Database Mirroring out there, but the following links provide the best information in the most consolidated format.
Microsoft has published a great whitepaper on Database Mirroring which starts from implementation basics and end up with best practices recommendations.
https://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx#EGAA (Database Mirroring in SQL Server 2005 - Whitepaper)
For other useful articles on database mirroring, its implementation, maintenance and removal, refer to this best source of information at MSDN.
https://msdn2.microsoft.com/en-US/library/ms177412.aspx
WEBCASTS
Rather than just reading about it, you can actually watch these amazing webcasts that showcase real world implementation examples with best practices recommendations.
How to Increase Availability Using Database Mirroring in SQL Server 2005 (Level 200)
SQL Server 2005 for the IT Professional (Part 8 of 11): Implementing Database Mirroring in SQL Server 2005
SQL Server 2005 for the IT Professional (Part 9 of 11): Implementing Database Mirroring in SQL Server 2005
BLOGS
For everything SQL, including Database Mirroring, this blog provides daily tips and tricks to effectively manage common scenarios on production servers.
https://blogs.msdn.com/sqltips/default.aspx
Business requirements such as service-level agreements and performance, as well as technical factors such as log generation rate, network throughput, and I/O throughput, influence the deployment of database mirroring. This paper discusses best practices and performance considerations for implementing database mirroring.
Database Mirroring and Log Shipping Working Together - Whitepaper https://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/DBMandLogShipping.docx
Implementing Application Failover with Database Mirroring - Whitepaper https://technet.microsoft.com/hi-in/library/cc917713(en-us).aspx
Database Mirroring: Alerting on Database Mirroring Events - Whitepaper https://www.microsoft.com/technet/prodtechnol/sql/2005/mirroringevents.mspx
Comments
- Anonymous
October 04, 2012
Can we use same ports for database mirroring for multiple instance in cluster ?