Database Mirroring in Microsoft SQL Server 2005
page 3 of 5
by Amit Bansal
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 25582/ 39

Steps and Setup

1. Identify your principal and mirror server. Optionally, you may want a witness server.

2. For practice purposes, the above 3 instances can be on the same server.

3. Take a full backup of the database on the principal server.

4. Restore the backup on the mirror server with "Restore with NoRecovery" option. Please remember the database name has to be the same.

5. The servers or instances involved in DB mirroring must trust each other. Each instance login must have rights to connect to the other mirroring server and to its end points.

6. The next step is to create database mirroring endpoints. You need admin rights for this. Endpoints need to be created on partner servers as well as the witness server, if any. You can do this using the Configure Database Mirroring Security Wizard, which you can invoke by clicking the Configure Security button on the Mirroring page of the Database Properties dialog. Or execute the CREATE ENDPOINT command using T-SQL. If you are setting up database mirroring on a domain, and all SQL Server instances use the same service login and password, you need not create logins on each server. This applies to workgroup model as well. If all SQL Server instances use the same service login and password, you do not need to create logins on the servers. Just leave the logins blank on the Configure Database Mirroring Security Wizard. Each database endpoint must specify a unique port on the server. When SQL Server instances are on separate machines, these port numbers can be the same. The Configure Database Mirroring Security Wizard will automatically suggest port 5022. If any of the SQL Server instances are on the same machine, each instance must have a distinct port and the port numbers must be unique.

7. Once you have set up the servers and the endpoints, you can start database mirroring. You again need admin rights. This can be done from Mirroring page of the Database Properties dialog or T-SQL.

Happy Mirroring


View Entire Article

User Comments

Title: good introduction   
Name: karan
Date: 2009-02-20 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: 2009-01-19 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: 2008-05-29 8:17:48 AM
Comment:
It is very nice to know the basic of Mirroring Database.

Thanks
Title: Mr   
Name: Balaji
Date: 2008-04-30 7:03:31 PM
Comment:
Thanks for the knowledge transfer
Title: THANKS A LOT.....   
Name: sukhmani
Date: 2008-04-15 3:43:34 AM
Comment:
hi amit,
very good article...
thanks a lot...
all d best...
Title: Mr.   
Name: Sen
Date: 2008-01-27 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: 2007-12-21 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: 2007-11-28 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: 2007-09-20 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: 2007-09-14 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: 2007-09-12 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: 2007-09-07 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: 2007-09-02 1:26:11 PM
Comment:
Hi, amit

good article. Keep writing.

thanks
Title: PRINCIPAL CONSULTANT   
Name: MAHADEV
Date: 2007-08-30 4:30:22 AM
Comment:
GOOD TO KNOW ARTICLE
THANKS
Title: Mr.   
Name: A. Jhunjunwala
Date: 2007-08-30 1:56:43 AM
Comment:
It was nice.
Title: Ms.   
Name: Mandira
Date: 2007-08-30 1:54:24 AM
Comment:
I work as SQl DBA, so the article was pretty useful or me.
Title: Mr.   
Name: Soumitra
Date: 2007-08-30 1:52:55 AM
Comment:
The article was lengthy but I liked it very much.
Title: Mr.   
Name: Arnab
Date: 2007-08-30 1:50:54 AM
Comment:
Interesting and informative.
Title: Ms   
Name: Suks
Date: 2007-08-30 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: 2007-08-30 1:43:42 AM
Comment:
Very informative
Title: Good Article on Data Mirroring   
Name: Jayant Jindal
Date: 2007-08-30 12:04:04 AM
Comment:
Very Good Article to get an insight for Data Mirroring in SQL Server
Title: Mr.   
Name: Rahuk
Date: 2007-08-28 12:56:02 PM
Comment:
neat and clean






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


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-03-28 3:57:31 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search