Veritas Backup Exec 10 Error

[SpanishFry]

We just installed a new tape system and I've got the schedule set and have run a few incremental backups with no problems. When I cam in this morning I got this error message from the full backup set to run ober the weekend. How can I get this databse to pass the consistency check?


e0008443 - One or more SQL Database consistency checks have failed.
For additional information regarding this error refer to link V-79-57344-33859

This is the message I get when running my full backup. The link at the end brings me to a "No Documents Matched Your Search" page. Obviously there is a problem with one of the databases but I was wonering what should I do so that I am able to backup my server?

Here's what's in the job log:
Consistency checking EVEREST_DCS704
An unknown or unexpected database error occurred while attempting a DBCC.
DBCC results for 'EVEREST_DCS704'.

 

[dphantom]

Make sure you have the remote SQL agent installed and your DB admin is not doing maintenance on the databses at the same time the backup job is running. Below are some other things to check for from the Veritas site.

http://forums.veritas.com/discussions/index.jspa

1. Perform a backup with the "Consistency Check before Backup" and "Consistency Check after Backup" options kept to None. These options can be located under the Backup job properties >> SQL option.
2. Verify that the logon account used has administrator rights to the Windows server that the SQL instance is installed on.
3. The consistency check that is run is actually a part of the SQL 2000 program and Backup Exec merely triggers the consistency check. This may also indicate that the database may be in an inconsistent state. Please try running DBCC manually through SQL and check if it reports some error.
- If the DBCC is successful, try running the Backup Job again with SGMON running in the background.

For additional information on SQL Consistency Checker Utility, please refer to the following TechNote:
http://seer.support.veritas.com/docs/242004.htm

We hope this will help.

 

[SpanishFry]

Thanks. Will check it out.