[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 353
  • Last Modified:

sql 2088 r2 mirroring

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
IKtech
Asked:
IKtech
  • 3
  • 2
2 Solutions
 
Ramesh Babu VavillaCommented:
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
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
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
 
IKtechAuthor Commented:
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Ramesh Babu VavillaCommented:
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
 
IKtechAuthor Commented:
"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
 
Ramesh Babu VavillaCommented:
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.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now