Backup Exec Failed to Back up the SQL Database Due to a DBCC Problem

Publication Date:  2012-07-19 Views:  329 Downloads:  0
Issue Description
The Backup Exec 2010 was used to back up the MS SQL database. The job run for tens of hours and ended up in failure.
The job log printed the error information shown in the following figure.
<a pic deleted here>
Alarm Information
None
Handling Process
Recover the UFDATA_126_2007 instance that encounters an inconsistency problem. Then execute the backup policy again.
Disable the consistency check when you set the backup policy. In this case, the backup database instances are inconsistent with the original instances. To disable the consistency check, do as follows:
Choose Backup Job Property > Settings > Microsoft SQL > Consistency Check Before Backup. Then select No.
Exclude the problematic instance UFDATA_126_2007 from the instances to be backed up from the backup policy.
Root Cause
During the analysis on the job error information, the prompt message shown in the following figure was discovered.
Suggestions
Flexibly adjust the backup policy as required.

END