V-287-11 - Database Maintenance Failure - Maintenance has failed: 11, Check database failed.
Article ID: 100022837
Updated On:
Description
Error Message
V-287-11 - Final error: 0xe0008443 - One or more SQL Database consistency checks have failed. "BEDB - Maintenance has failed: 11, Check database failed".
Resolution
This issue occurs if there are database inconsistencies detected when attempting to backup the database during the scheduled maintenance time. The issue can be resolve by using the OSQL utility or using the Microsoft SQL Server Management Studio Express.
To resolve using OSQL:
1) Go to command prompt and type:
osql -E -S server name\INSTANCENAME ( Default localhost\bkupexec )
If successfully connected to the server, the following prompt appears:
1>
1>
This indicates a connection to the instance using OSQL
2) Run the Database Consistency checks by selecting BEDB database.
1> use BEDB
1> use BEDB
2> go
On the prompt 1>, type :
1> DBCC CHECKDB
2> go
3) Check Database consistency output :
CHECKDB found x allocation errors and x consistency errors in database 'BEDB'.
4) If errors exist, the DBCC output typically will inform user what command to run in order to fix.
example:
There are 2 rows in 2 pages for object "RestoreScriptEntries".
Msg 2508, Level 16, State 1, Server SVRUSFS01\BKUPEXEC2, Line 1
The In-row data USED page count for object "Partition", index ID 1, partition
ID 357338084671488, alloc unit ID 357338084671488 (type In-row data) is
incorrect. Run DBCC UPDATEUSAGE.
Msg 2508, Level 16, State 1, Server SVRUSFS01\BKUPEXEC2, Line 1
The In-row data USED page count for object "Partition", index ID 1, partition
ID 357338084671488, alloc unit ID 357338084671488 (type In-row data) is
incorrect. Run DBCC UPDATEUSAGE.
5) Run the appropriate command mentioned and then rerun the DBCC CHECKDB until there are no errors
To resolve using Microsoft SQL Server Management Studio Express:
1) Download and install Microsoft SQL Server Management Studio Express
2) Launch Microsoft SQL Server Management Studio Express and connect to the Backup Exec instance of SQL (ie, \BKUPEXEC)
3) Click on the "New Query" button and type the following:
USE BEDB
GO
DBCC CHECKDB
GO
4) Check Database consistency output :
CHECKDB found x allocation errors and x consistency errors in database 'BEDB'.
5) If errors exist, perform same steps to resolve as using OSQL command above.
Once all errors are resolved, run the Database Maintenance from Tools -> Options -> Settings -> Database Maintenance by changing the schedule.
Issue/Introduction
Database Maintenance Failure - Maintenance has failed: 11, Check database failed.
Additional Information
UMI: V-287-11
Was this article helpful?
Yes
No
Powered by
