Database Mirroring in Microsoft SQL Server 2005
page 1 of 5
Published: 28 Aug 2007
Abstract
This article provides a brief overview of database mirroring in SQL Server 2005.
by Amit Bansal
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 27482/ 69

Introduction

Fast failover with minimal data loss has traditionally involved higher hardware cost and greater software complexity. Database mirroring, however, can fail over quickly with no loss of committed data, does not require proprietary hardware, and is easy to set up and manage.

Poor man's clustering solution, cost effective failover solution, whatever you call it, Database Mirroring is one of the most talked about features in SQL Server 2005.

In DB Mirroring, a SQL Server 2005 instance continuously ships its transaction log records to a copy of the database on another SQL Server instance. So you have the principal server and the mirror server. However, the names are relative since the roles can be switched over in case of a failover. These are considered as partners. We may also have a third server called the witness server allowing for automatic failover. With the presence of the witness server, a quorum is formed. If the principal server goes down, the mirror server can take the role of the principal in a few seconds after getting a confirmation from the witness server. Not to mention, in the absence of a witness server the failover has to be performed manually either through SQL Server Management Studio or T-Sql.


View Entire Article

User Comments

Title: good introduction   
Name: karan
Date: 2/20/2009 2:50:00 AM
Comment:
It is very nice to know the basic of Mirroring Database

give more issues while setup
Title: Database Mirroring in Microsoft SQL Server 2005   
Name: Parveen Siwach
Date: 1/19/2009 8:42:13 AM
Comment:
Looking forward to more articles on Database Mirroring Failover by you. Good Effort. All the Best!!!!

Thanks Amit
Title: Good Intro   
Name: Shashi Kumar Singh
Date: 5/29/2008 8:17:48 AM
Comment:
It is very nice to know the basic of Mirroring Database.

Thanks
Title: Mr   
Name: Balaji
Date: 4/30/2008 7:03:31 PM
Comment:
Thanks for the knowledge transfer
Title: THANKS A LOT.....   
Name: sukhmani
Date: 4/15/2008 3:43:34 AM
Comment:
hi amit,
very good article...
thanks a lot...
all d best...
Title: Mr.   
Name: Sen
Date: 1/27/2008 4:28:50 AM
Comment:
Very Interesting. Looking forward to more articles by you. Good Effort. All the Best!
Title: Mr.   
Name: Ambalavanan Chithambaram
Date: 12/21/2007 1:54:52 AM
Comment:
Amit,
My special thanks to you for such a apt presentation of mirroring concepts.Please do keep writing so we people will keep on reading and utilising it.
All the best for your noble efforts. Please do keep continuing...
Thanks.
Title: Mr.   
Name: Jeet
Date: 11/28/2007 5:53:06 AM
Comment:
Indeed superb, I was lucky to be part of its demonstration too by Amit.....kudos to Amit!
Title: Mr   
Name: Visagan
Date: 9/20/2007 3:03:13 AM
Comment:
Hi Amit,
Hi Amit,
iam one of the guy who attended the Training in Bangalore,
It was a good training and it helped me to learn SQL Server better than beffore.
Title: Mr   
Name: Subhrendu Guha Neogi
Date: 9/14/2007 9:47:41 AM
Comment:
Hi Amit,
Its too good and I hope you will write such again and again.
Title: Mr   
Name: Manjunath Sinnad
Date: 9/12/2007 6:51:33 AM
Comment:
Hello Amit,

This is wonderful document.Please send link to doc on performance tuning.
Title: Hello Amit   
Name: Raj Mohapatra
Date: 9/7/2007 5:03:33 AM
Comment:
Hi Amit,

Good Article!!!
On my Rank 10/10.
Keep it up.

Thanks
Raj
Title: Mr.   
Name: pradeep phuloria
Date: 9/2/2007 1:26:11 PM
Comment:
Hi, amit

good article. Keep writing.

thanks
Title: PRINCIPAL CONSULTANT   
Name: MAHADEV
Date: 8/30/2007 4:30:22 AM
Comment:
GOOD TO KNOW ARTICLE
THANKS
Title: Mr.   
Name: A. Jhunjunwala
Date: 8/30/2007 1:56:43 AM
Comment:
It was nice.
Title: Ms.   
Name: Mandira
Date: 8/30/2007 1:54:24 AM
Comment:
I work as SQl DBA, so the article was pretty useful or me.
Title: Mr.   
Name: Soumitra
Date: 8/30/2007 1:52:55 AM
Comment:
The article was lengthy but I liked it very much.
Title: Mr.   
Name: Arnab
Date: 8/30/2007 1:50:54 AM
Comment:
Interesting and informative.
Title: Ms   
Name: Suks
Date: 8/30/2007 1:44:07 AM
Comment:
Very detailed article. Gives a good insight into the SQL DB Mirroring. Good piece of work!
Title: Mr   
Name: Gaurav Bhattacharya
Date: 8/30/2007 1:43:42 AM
Comment:
Very informative
Title: Good Article on Data Mirroring   
Name: Jayant Jindal
Date: 8/30/2007 12:04:04 AM
Comment:
Very Good Article to get an insight for Data Mirroring in SQL Server
Title: Mr.   
Name: Rahuk
Date: 8/28/2007 12:56:02 PM
Comment:
neat and clean






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2014 ASPAlliance.com  |  Page Processed at 4/24/2014 2:41:31 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search