Host-based backup of VMware vSphere VMs.
Post Reply
sdelacruz
Enthusiast
Posts: 64
Liked: 1 time
Joined: Feb 01, 2011 8:09 pm
Full Name: Sam De La Cruz
Contact:

SQL Backup Excluding Databases

Post by 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
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Backup Excluding Databases

Post by foggy »

Sam, could you please share what particular instructions led you to this behavior? Have you configured database exclusions?
sdelacruz
Enthusiast
Posts: 64
Liked: 1 time
Joined: Feb 01, 2011 8:09 pm
Full Name: Sam De La Cruz
Contact:

Re: SQL Backup Excluding Databases

Post by sdelacruz »

alanbolte
Veteran
Posts: 635
Liked: 174 times
Joined: Jun 18, 2012 8:58 pm
Full Name: Alan Bolte
Contact:

Re: SQL Backup Excluding Databases

Post by 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
Enthusiast
Posts: 64
Liked: 1 time
Joined: Feb 01, 2011 8:09 pm
Full Name: Sam De La Cruz
Contact:

Re: SQL Backup Excluding Databases

Post by sdelacruz »

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

Should I change the recovery mode to Full?
alanbolte
Veteran
Posts: 635
Liked: 174 times
Joined: Jun 18, 2012 8:58 pm
Full Name: Alan Bolte
Contact:

Re: SQL Backup Excluding Databases

Post by 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.
Post Reply

Who is online

Users browsing this forum: No registered users and 60 guests