SQL Backup Excluding Databases

VMware specific discussions

SQL Backup Excluding Databases

Veeam Logoby sdelacruz » Mon Dec 14, 2015 4:54 pm

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
sdelacruz
Enthusiast
 
Posts: 43
Liked: never
Joined: Tue Feb 01, 2011 8:09 pm
Full Name: Sam De La Cruz

Re: SQL Backup Excluding Databases

Veeam Logoby foggy » Mon Dec 14, 2015 5:13 pm

Sam, could you please share what particular instructions led you to this behavior? Have you configured database exclusions?
foggy
Veeam Software
 
Posts: 14765
Liked: 1083 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL Backup Excluding Databases

Veeam Logoby sdelacruz » Mon Dec 14, 2015 6:16 pm

sdelacruz
Enthusiast
 
Posts: 43
Liked: never
Joined: Tue Feb 01, 2011 8:09 pm
Full Name: Sam De La Cruz

Re: SQL Backup Excluding Databases

Veeam Logoby alanbolte » Mon Dec 14, 2015 7:01 pm

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).
alanbolte
Expert
 
Posts: 635
Liked: 170 times
Joined: Mon Jun 18, 2012 8:58 pm
Full Name: Alan Bolte

Re: SQL Backup Excluding Databases

Veeam Logoby sdelacruz » Mon Jan 18, 2016 8:37 pm

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

Should I change the recovery mode to Full?
sdelacruz
Enthusiast
 
Posts: 43
Liked: never
Joined: Tue Feb 01, 2011 8:09 pm
Full Name: Sam De La Cruz

Re: SQL Backup Excluding Databases

Veeam Logoby alanbolte » Mon Jan 18, 2016 8:43 pm

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.
alanbolte
Expert
 
Posts: 635
Liked: 170 times
Joined: Mon Jun 18, 2012 8:58 pm
Full Name: Alan Bolte


Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 19 guests