No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade
Knowledge Base

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

Publication Date:  2012-07-19  |   Views:  776  |   Downloads:  0  |   Author:  anliku  |   Document ID:  EKB1000007588

Contents

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.