Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imughal
Posting Yak Master
192 Posts |
 Posted - 2011-11-28 : 05:24:56
|
| Hi,i have two SQL SERVER with instance name like instance1 and instance2.i want to configure database mirroring between two.instance1 is my primary/principal serverinstance2 is secondary/mirror server.i login to principal server select database and select mirror.click on security to configure mirroring. first wizard ask me principal server instance name i select instance1 and ask for mirror server instance name i select instance2. mirroring done successfully.problem is that when i launch mirroring dashboard its shows principal server connection with instance name that is instance1 and mirror server connection show with computer name nit with instance name. i believe it should show like instance2 but not.pls tell what is the issue and how to correct it.thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
imughal
Posting Yak Master
192 Posts |
Posted - 2011-11-28 : 23:15:48
|
| if its bug how to confirm and fix |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
imughal
Posting Yak Master
192 Posts |
Posted - 2011-11-30 : 02:02:23
|
| just to confirm that if we change computer name then what happen at time of failover, where we have configure failover at instance name and instance name remain same.will it effect..? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
imughal
Posting Yak Master
192 Posts |
Posted - 2011-11-30 : 23:31:28
|
| yes, if i rename host name than what will be the impact on mirroring. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL Mirroring on instance name