June 4, 2008 at 12:59 pm
As a result of Principal serverA failure (in case of High-Safety with Witness) Mirror serverB took the role of Principal. After repairing failed serverA automatically assumes the role of Mirror. How can I switch roles back, i.e. return to serverA = Principal and serverB= Mirror? I certainly can imitate failover but probably there is more elegant/painless way? Thanks
June 4, 2008 at 1:16 pm
June 4, 2008 at 1:20 pm
Thanks, Steve, but this approach deals with failover (manual). I thought there is another way (not related to failover). Probably I was wrong
June 4, 2008 at 1:27 pm
When the roles are switched, you want a failover. That will move things back.
ServerA - Principal
ServerB - Mirror
Event happens, server A fails, etc. You now have:
ServerA - Mirror (down)
ServerB - Principal
When you fix ServerA, it's still the mirror. If you failover, then you get back to where you started.
June 4, 2008 at 1:28 pm
My understanding is that you have to do a manual failover.
ALTER DATABASE MyDatabase SET PARTNER FAILOVER
Ola Hallengren
June 4, 2008 at 1:55 pm
Thanks gents- it seems that the only way we can switch roles back is over manual faiover
June 4, 2008 at 2:13 pm
My experience is that this is a very fast and easy method.
(Another thing. How do you have your backups start automatically on the mirror server after a failover? I have a maintenance solution that has been designed for database mirroring. http://ola.hallengren.com/sql-server-backup.html)
Ola Hallengren
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply