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
JustinGSEIWIAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JustinGSEIWIAuthor Commented:
Thanks.

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

Justin
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.