I was running security updates on the sql server mirror setup and I encountered split brain scenario as mentioned here
Should I pause Mirroring and stop SQL Server services before running windows updates?
So to fix this issue I turned off database mirroring.
Now I am trying to find a way to restore database mirroring.
Would simply turning on database mirroring solve the issue? , Would the transaction logs automatically update?
Or Should I take a full back and transaction log and restore the database. I would prefer option 1 if that is possible , because in option I have to setup the logins again .
what's the best practice to resolve a split brain issue?
Incase you are already in a situation where db's on principal and mirror are in recovery mode. (This could occur due to many reasons like certificate expired network failures) etc, what's the best way to resolve such a situation, do you need pause mirroring and fix the issue?
I turned off database mirroring
- what steps you exactly performed ?