cancel
Showing results for 
Search instead for 
Did you mean: 

Database consistency check error on BKUPEXEC instance

Lee_Thacker
Level 3

Backupexec 11d (Latest updates via live update)
SQL Module
SQL Server 2005
Windows 2003 Server standard SP2

We have upgraded one of our SQL servers from Backupexec 10.d to 11d.  We un-installed version 10d deleted the SQL instance and then installed backupexec 11d and selected to use a SQL express instance during installation.


Backups now fail with the following error (When the Backupexec database is selected for backup):

Job Completion Status
Job ended: Wednesday, May 02, 2007 at 4:19:57 AM
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- SARUMAN\BKUPEXEC An unknown or unexpected database error occurred while attempting a DBCC. 

Any Ideas?

Regards

Lee

9 REPLIES 9

Hywel_Mallett
Level 6
Certified
You could have a look at SQL consistency check errors
However, you don't need to select the BEDB database. Backup Exec creates a BEDB.bak file (during database maintenance) which would be included as part of the media server backup. The Backup Exec database can be restored from this file.

Hywel_Mallett
Level 6
Certified
Nice server name BTW! Smiley Very Happy

Lee_Thacker
Level 3
Hi Hywel
 
Thank you for the information it has proved to be very usefull :)
 
Kind Regards
 
Lee.

Optimus_Prime
Level 5
Partner
How this issue resolved? KIndly someone update this concern instead doing another forum.

Optimus_Prime
Level 5
Partner
How this issue resolved?

CraigV
Moderator
Moderator
Partner    VIP    Accredited
Hi Optimus,

I suspect that the guy was trying to backup the SQL DB without a license, and this was causing the issues in his backups!

Laters!

Symanticus
Level 6
No Craig,

I also facing the same problem here: The job failed with the following error: One or more SQL Database consistency checks have failed.

this is backing up SharePoint 2007 which of course we must backup the SQL server content.

any clue for this please ?

sksujeet
Level 6
Partner    VIP    Accredited Certified
Please try to uncheck the consistency check for the sql database and see if it works. It might be the sql consistency check and your sql might not be consistent. You have to run the consistency check from sql to find what might be the issue with sql.
As BE just give the command to BE to run the consistency commands on the sql

CraigV
Moderator
Moderator
Partner    VIP    Accredited
Guys, this should be a new forum query...not a piggy-back. MOre people will respond if it is new.