SQL Backup Excluding Databases

[sdelacruz]

Hello,

Recently I configured a new SQL server to be backed up by Veeam. After following the instructions in the user's manual, I now am receiving an email alert stating that all my databases are being excluded. Only the model database show as protected. Is there any other setting I need to enable to protect the rest of the Dbs?

Code: Select all

Database StatusSuccessWarningErrorsReadTransferredDetails
masterExcluded24000.0 KB0.0 KB
modelProtected24002.0 MB78.9 KB
msdb Excluded24000.0 KB0.0 KB
ccwinExcluded24000.0 KB0.0 KB
WebbExcluded24000.0 KB0.0 KB
WebbExcluded24000.0 KB0.0 KB
CountyterExcluded24000.0 KB0.0 KB
Web1Excluded24000.0 KB0.0 KB
Web2Excluded24000.0 KB0.0 KB
Web3Excluded24000.0 KB0.0 KB
Web4Excluded24000.0 KB0.0 KB
Web5Excluded24000.0 KB0.0 KB

These are the results I get on my email

[foggy]

Sam, could you please share what particular instructions led you to this behavior? Have you configured database exclusions?

[sdelacruz]

I used the following link

http://helpcenter.veeam.com/evaluation/ ... html#step1

[alanbolte]

http://helpcenter.veeam.com/backup/80/v ... stats.html

Excluded — databases excluded from processing. This may be due to any of the following reasons: database status is Offline, database recovery model is set to Simple, database is read-only, database was deleted after the latest full backup, registry key value (list of exclusions).

[sdelacruz]

It looks that the database recovery mode was set to Simple.

Should I change the recovery mode to Full?

[alanbolte]

If you want to perform point-in-time restores, yes. With simple logging, you will only be able to restore to the times the entire SQL server was backed up. Don't change the master database though, full logging isn't supported for that.