?
Solved

sql 2088 r2 mirroring

Posted on 2013-05-21
6
Medium Priority
?
345 Views
Last Modified: 2013-07-17
SQL server 2008r2 has been setup using mirroring for some time.  Today in order to fix another issue i uninstalled vmware tools on the sql server that is usually the principal.
This removed the network card and installed a new one.  

To make a long story short i noticed after adding the static ip for the sql principal server, the network card of other sql server (which is where the mirror databases are stored) has two ip addresses assigned to the network card.  I know i only gave it one address when i set that server up but it now has two.

is this normal behavior after setting up mirroring (one network card in the sql server has two ip addresses)?  If yes then why doesn't my principal server have two ip addresses after i uninstalled and reinstalled the NIC (this happened as a result of reinstalling vmware tools).

Should i restart with mirroring and and delete the mirror databases and recreate them?

I am thouroughly confused as to how this is supposed to be setup and the question is probably just as confusing.  Please help experts!!
0
Comment
Question by:IKtech
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 10

Expert Comment

by:Ramesh Babu Vavilla
ID: 39186596
it is advised to restart the End Point of the mirroring.

if you databases are small in size then re create then i think it is the very easy job.
0
 
LVL 23

Accepted Solution

by:
Racim BOUDJAKDJI earned 750 total points
ID: 39186789
Recreating the mirroring seems the safest way...As mentioned above, if the databases are small that should not be too difficult.

Hope this helps...
0
 
LVL 3

Author Comment

by:IKtech
ID: 39188082
how about the ip addresses?  The principal server is 10.1.0.100 the mirror is 10.1.0.101.  On the mirror server both these ip address appear in the properties of the NIC.  Is that normal?
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
LVL 10

Assisted Solution

by:Ramesh Babu Vavilla
Ramesh Babu Vavilla earned 750 total points
ID: 39188878
yeah thats fine with the IP address, as Mirroring is configured and executed with the
port number and the FQDN fully qualified DOmain Name

but make sure that the application connection string have the same ip in common
0
 
LVL 3

Author Comment

by:IKtech
ID: 39226034
"but make sure that the application connection string have the same ip in common"

Could you perhaps give me a brief description on how to check the connection string
0
 
LVL 10

Expert Comment

by:Ramesh Babu Vavilla
ID: 39335486
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question