I have 2 SQL servers in Mirror configuration.
I want to backup these servers but backing up the SQL databases in Mirror state causes an error.
These two mirrors also have a witness set.
I would like to know how do I create full daily backups from the Principal server only meaning that if the current server is set to principal the backup will work, otherwise it won't.
Thank you for your assistance!