I want to use Data Protection Manager 2007 to backup two servers with SQL-server that have several mirrored databases.
On Maintenance plan for SQL Server Database Mirroring someone helpfully describes that for e.g. a maintenance plan one has to roll custom scripts to enable or disable these plans.
Now if I use the DPM 2007 GUI to select what to protect I won't see the databases on the second server that are in recovering state.
What should I do?
Can I somehow make SQL server (2005) to prefer one instance over the other so that the mirrored database always switches back to the main node after e.g. automatic windows updates?
Or should I "trick" DPM by first planning a backup of all database on the first node, then do manual failover and then reselect them?
I have not tried it, will it tolerate the failures? Or stop working? In any case I think it will nag regularly.
Anyway, have the data backuped twice is redundant.