How to Ignore Offline Databases During Backup

If one of your databases is offline when SqlBak performs scheduled backup you will receive the following error:

Failed to backup "Adventureworks" database with "Full" backup type: Database 'Adventureworks' cannot be opened because it is offline. BACKUP DATABASE is terminating abnormally.

You can avoid this issue with the help of SqlBak’s feature called “Ignore Offline databases“. You can apply this option to any of your databases that might be offline. It means that when the scheduled backup job starts it will ignore offline databases and instead the error message only warning message will be added to the log:

Skipping "Adventureworks" database backup. Reason: [DBMS:11003#0] Database "Adventureworks" is "Offline".

As shown in the picture below the backup status is “SUCCESS” and the database with the name “Adventureworks” which is offline has been skipped and another “DB” database has been backed up on the folder.

Ignore Offline databases (Backup log)

How to Setup “Ignore Offline Databases” Option.

To setup “Ignore Offline databases” option open your current backup job or create a new one from Dashboard page. Ignore offline databases DashboardNow in the Backup Settings page go to item 11 “Backup options” and tick  “Ignore Offline databases”. How to setup Ignore offline database

Press “Create” button to save new changes. Now SqlBak will ignore all offline databases during backups.

Leave a Reply

Your email address will not be published. Required fields are marked *