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 |
|
chris_cs
Posting Yak Master
223 Posts |
 Posted - 2008-06-05 : 04:57:48
|
| I have a quick question regarding mirroring failover. If you have mirroring setup with a witness and the principal server goes down, once the principal is back up as the mirror will it automatically synchronize with the new Principal?The main thing that I wasn't sure of is that if it took a fair amount of time to bring the original principal back up, the new principal will be in production so will all the new transactions be sent to the mirror once it is available? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-05 : 10:27:33
|
| If you are doing automatic failover and principal server goes down, your mirror server will be principal server .Your old principal server will be mirror after it comes up. If any issues with new pricipal,your old principal will be Principal. You can manually failover as well. |
 |
|
|
|
|
|
Mirroring question