Backups failing! - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Backups failing!

Author

Topic

Zoma
Yak Posting Veteran

76 Posts

Posted - 2010-02-17 : 02:09:14

Hi all

One of our system eng. who manages the server remotely. He use Backup exec for database backups. and he just told me some 2databases are causing all the other database backup to fail.

Error:
Job Completion Status
Job ended: Tuesday, February 16, 2010 at 6:04:35 PM
Completed status: Failed
Final error: 0xe0008443 - One or more SQL Database consistency checks have failed.
Final error category: Resource Errors

V-79-57344-65085 - There was a problem running the DBCC.
DBCC results for 'EE'.
V-79-57344-65085 - There was a problem running the DBCC.
DBCC results for 'EE_Archive'.

And after i got the mail i connected on my SQL MS. To check this databases using the DBCC CHECKDB Statement, but somehow i get errors after i run the statement.

Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=174623665,referenced_minor_id=4) of row (class=0,object_id=302624121,column_id=0,referenced_major_id=174623665,referenced_minor_id=4) in sys.sql_dependencies does not have a matching row (object_id=174623665,column_id=4) in sys.columns.

Msg 2508, Level 16, State 1, Line 1
The In-row data USED page count for object "ETT_A_TIME_SUMMARY_PER_PERSON", index ID 2, partition ID 580367325331456, alloc unit ID 580367325331456 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
Msg 2508, Level 16, State 3, Line 1

I have also tried the updatusage statement and it gives me an error as well. Both the databases are in simple mode.

Thank you

DaleTurley
Yak Posting Veteran

76 Posts

Posted - 2010-02-17 : 07:26:47

This; is becuase you have a view, or stored procedure that i referenceing an object that doesn't exist any more.

Try running SELECT OBJECT_NAME(174623665) to see what is the referencing object.

Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=174623665,referenced_minor_id=4) of row (class=0,object_id=302624121,column_id=0,referenced_major_id=174623665,referenced_minor_id=4) in sys.sql_dependencies does not have a matching row (object_id=174623665,column_id=4) in sys.columns.

Zoma
Yak Posting Veteran

76 Posts

Posted - 2010-02-18 : 02:36:38

Hi Thanks for your help. I have run the SELECT OBJECT_NAME(*******)
And it brings me the result of an Object that still exist on both databases and it is a table.
May it be that there is a stored procedure or a view that is no longer there but still referenced to this table?

Kristen
Test

22859 Posts

Posted - 2010-02-18 : 03:33:37

Dunno if it is helpful but

EXEC sp_depends 'MyTable'

will tell you what is referencing that object

From that you might be able to work out what is no longer present.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources