Video Screencast Help

Be 2010 MS SQL Agent mirrored database

Created: 26 Mar 2010 • Updated: 05 Jul 2011 | 4 comments
This issue has been solved. See solution.

Hi!

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?

Best regards,

Michael

Comments 4 CommentsJump to latest comment

pkh's picture

Deselect the mirrored database and backup only the principal database.  See the document below

http://www.symantec.com/business/support/index?page=content&id=TECH67641

SOLUTION
Andreas Pross's picture

In my case, I have automatic failover. So one day, server1 is the principal and maybe after windows update or something else, server2 may be the principal. Even if I create a script which forces a fallback to server1. If server1 is down for some reason, I will not have any backup or i have to manually change the backup jobs. So there is a chance that I haven't a backup for a few days if no one is there to change the backup jobs after a failover.

The best way would be the ability to specify principal and mirror and backup exec could decide which is online and should be backedup.

The other way would be an option to allow backup exec to ignore the mirrored database. So i can select it, but wouldn't get an exception if it is mirrored.

pkh's picture

You can suggest this as an Idea (see Ideas section).  If enough users vote for your suggestion, then it might be incorporated in some future release of BE.