I know this questions might have bee asked sevelar times before but I have searched over and over agagin and I cant find a solution for it.
Anyway, here it goes:
I have a few databases configured for mirroring and I want to configure maintenance plans for them. Now, the plan should of course only run on the principal server but how can I make this happen after a failover?
Is it possible to set up the maintenance plans on both principal and mirror server and then only have them executed on the principal.
I want this to happen automatically. If for example the databases fail over automatically during the night I want to be sure that after failover the transaction logs are still backed up.