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.