Be 2010 MS SQL Agent mirrored database
I would like to know if anyone have any insights into making a successfull backup of a MS SQL 2008 mirrored database.
I have a backupset include both nodes of the mirroed SQL servers, but the backup always fails with:
V-79-65323-954 - The database "<name>" cannot be opened. It is acting as a mirror database
I understand that it's not possible to do a backup of a mirrored database, but if BE can detect that the DB is mirrored then it should not throw an error, but only an information regarding the mirror, as the principal DB is being backed up correctly.
Is there any way to make BE understand that the DB is mirrored and not throw an error, resulting in a failed backup job?