zedtec (3/13/2014)
Hi,I just wanted to know what would happen in the scenario where you've got database mirroring configured over a WAN and one site goes down and loses connection with the other site.
do you have a witness configured and which site does it reside on?
zedtec (3/13/2014)
The failover takes place and the mirrored DB now becomes the Principal DB.However, the site where the mirrored DB should now be is still down.
Will DB mirroring and the Principal DB continue to run if it has no mirror?
If so, then can users make changes to the principal DB and query it as normal?
Thanks.
If i'm right you're saying your principal goes down and the mirror becomes the new principal. The old principal cannot act as mirror as it's down.
You're asking, Will the new principal function ok and will the mirroring session still be configured.
The new principal would be online and accessible to users. As soon as the old principal comes back it will rejoin the mirror session as the new mirror and the session will be marked suspended. To continue you'll need to resume the session using the following command from the new principal
alter database [yourdb] set partner resume
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉