VEEAM SQL Backups and Read-Only databases

[MSJ]

Having just switched another SQL instance to use the VEEAM SQL plugin we started to receive the following errors: -

Failed to backup database ABC. Error: Database ABC is read-only and can be backed up only in full mode. Failed to check backup prerequisites for database ABC

If VEEAM won't take log backups of READ-ONLY databases, why doesn't it automatically just skip them rather than reporting the error?

Will this also cause an issue with weekly full & daily differential backups?

[PetrM]

Hi Mike,

We will improve this behavior in future releases. It won’t cause any issues with full backups, but I’m not sure about differential backup, I need to check. Do you use the plug-in in standalone mode or managed mode? Could you possibly just exclude this database from processing and create a dedicated job for it?

Thanks!

[MSJ]

Hi - Thanks for update - I am using command line, called from a generic powershell script to run the SQL backups. The script runs across multiple SQL instances on multiple servers. I am looking to add some further code to generate the exclude parameter for any read-only databases when the script runs for log backups.

[PetrM]

Hi Mike,

What about the --ed parameter?

Specifies the name of the database that must be excluded from the backup.
This parameter is optional. If you do not use this parameter, Veeam Plug-In will back up all databases of the specified instance.
Alternatively, if you want to back up a specific database, you can use the --d parameter and specify the necessary database as its value.

Thanks!

[MSJ]

Yes, that is the one, I am going to dynamically generate the --ed parameter for all databases that are read-only when the script runs for LOG or DIFF backups