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 |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2011-08-17 : 08:48:50
|
| If you restart a SQL Server instance that has mirroring in place can it cause any issues when it comes back online?Will mirroring still be in place after the restart? Will the principal and mirror roles still be the same as prior to the restart.This is for asynchronous mirroring with no witness. |
|
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2011-08-17 : 11:30:57
|
| If automatic failover isn't set up then yes, the mirror will say 'Disconnected' while the server is down, then 'Synchronizing' and then 'synchronized' when everything is back in synch. |
 |
|
|
|
|
|
Restart SQL Server with mirroring in place