|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 725
|
Hi,
We have a mirrored SQL 2008 setup.
If i try to backup a Mirrored database, the program registers it as an error:
Backup of <DB> failed: The database <DB> cannot be opened. It is acting as a mirror database.
I would like to have SqlBackupAndFTP installed on both SQL servers and backup the same databases, in case of an error and the mirrored database failovers.
But then the backup job registers the fail, even though i didn't want it to.
So my feature request is:
Add an checkbox or so, that if checked, excludes Mirror database backup failures.
Hope it makes sense :-)
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
Morten,
I did not get it why would you want to backup a mirrored database. Obviously it is not allowed and obviously it fails.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 6/3/2011
Posts: 2
|
Hi ruslan,
Thanks for your reply.
My scenario is this:
I have SQL server A and B, and want to install SQLBackupAndFTP on both servers.
All databases in this setup are mirrored, but not nescesarily mirrored from A->B , where B is mirror.
Example:
Database:Primary:Mirror
db1:A:B
db2:B:A
db3:A:B
For maximum security, and to be sure that DB backup is always performed, i want to use "Backup all non-system databases" feature on both servers.
So if "db1" changes it's primary server to B, just before backup, it will still make a succesfull backup on server B, without reporting a "mirror" backup failure on server A.
Hope that clears things up.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
I see your point now. It is probably too specific to your case to add options in SBF to handle it. I hope that just selecting the primary databases on each server instead of "Backup all" is not too much of an overhead.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 6/3/2011
Posts: 2
|
Hi ruslan,
Actually it's not a problem to select each primary server.
The problem is that, if the database changes primary server unattended(failure), i may not be able to change the backup settings before backup.
Thereby the backup would fail.
I see your point, it's a very specific feature and would not be needed by the majority of your users.
But unfortunately without this feature we cannot use the program.
Thank you for taking the time to investigate.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
If it is a rare occasion that db changes primary server, you can setup email notification (I think) about it, then change backup to backup the DB that was mirror and became primary.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 8/2/2011
Posts: 1
Location: Enschede
|
Hi Ruslan,
We are also looking into using SBF and we do have several Clustered SQL servers with several mirrored databases. Unfortunately sometime we do have an failover.
When this happens we would like to see the backup picks it up and proceeds backing up all databases that are active.
Maybe a check box "Exclude when it is acting as a mirror database" ?
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
I guess without adding any additional checkboxes we may check if the database is primary. If it is not - no point to attempt backing it up. We probably could just write in the log: "Mirrored database XXX - skipping the backup"
|
|
|
|
|
