12-21-2018 07:27 AM
|
I get this error on my FULL and Incremental jobs every night. However, when I perform a database consistency check manually directly on the Backup Exec Database (https://www.veritas.com/support/en_US/article.TECH144229), it shows 0 errors and 0 inconsistencies. Are these errors not related to the Backup Exec Database, but the actual SQL databases that are being backed up during the job? If so it would be too strange that all of my SQL databases that are being backed up would be having the same issue. More or less it seems more likely that the error is false since the backup jobs are capturing the data and restores seem to be working. However, I need to figure out for sure if there a problem.
12-21-2018 07:48 AM - edited 12-21-2018 07:49 AM
The errors relate to what you back up
And I think there is a setting to continue the backup even if the consistency check fails (which you may have enabled)
As such (assuming you backup more than 1 database in the job) you will need to look at which databases have the problem to understand where the fault is
12-26-2018 11:31 AM
Okay - I performed a dbcc checkdb on all of the databases and servers being backed up. 0 errors 0 inconsistencies. What is going on here? I see that there is an option to check physical_only (default), full include indexes, full, exclude indexes. Also, I can perform checks before and after the backup. Does that fact that these are virtual servers have anything to do with why the default (Physical_Only) check might be failing? I'm doing tape backups. I'm thinking about just selecting none as the database consistency check to bypass this false error. Please help me undersand this.