• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2228
  • Last Modified:

Backup Exec failing with DBCC error

My Backup Exec SQL job is failing with a DBCC check error. The error is below.

Job ended: Tuesday, August 5, 2014 at 1:41:32 PM
Completed status: Failed
Final error: 0xe0008443 - One or more SQL Database consistency checks have failed.
Final error category: Resource Errors

For additional information regarding this error refer to link V-79-57344-33859

 

Errors
Click an error below to locate it in the job log
Backup- SQLRI.AD.GC.ORG V-79-57344-65085 - There was a problem running the DBCC.

DBCC results for 'MVGSC'.


 This database is only used maybe once or twice a year and is not important. However, this one issue causes the job to fail. I ran dbcc checkdb command in SQL and I have attached the results.

I do want the backup to run the DBCC but I need to resolve this so that I can have my jobs run successfully instead of fail. What can I do to resolve this issue?

Thanks,

Justin
dbcc.txt
0
JustinGSEIWI
Asked:
JustinGSEIWI
1 Solution
 
Fudge5000Commented:
Justin,

You should do a normal full SQL backup first before you try the following.

Looking at the output provided it just looks like you need to run the DBCC UpdateUsage on the database. This should sort out your errors.

Just use:   DBCC UPDATEUSAGE (YourDatabaseName)

Let it run then do your checkdb again and see if you receive anymore errors. This has happened to me on a couple of occasions and this approach has always worked.

Kind regards
0
 
JustinGSEIWIAuthor Commented:
Thanks.

I executed that command and now I will see if my backup is successful tonight.

Justin
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now