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!!