I have the following scenario which I was hoping to resolve using a job if possible. We have databases across 2 servers some of which are primary on (a) and some are primary on (b). Once per month the server is patched and reboots - All DB's failover to their mirror at this point, as they should.
I would like to know if there is a way of failing the databases that have moved off their primary server to their mirror back to their original location (once the patching is complete). At the moment this is done manually by right-clicking-tasks-mirroring-failover and it doesn't seem to be an efficent way of doing this.
Can I create a job to do this task, perhaps something that can run hourly?