CHECKDB finds consistency errors in table 'sysdepends'

  • Thread starter Thread starter Angelo Brusati
  • Start date Start date
A

Angelo Brusati

I've tried to follow any kind of tips for the solution og this problem, but
I cannot use the repair tools because of the system table "sysdepends".
What can I do? The regular integrity check, database and transaction log
backups fail every single day!

The error, according to CHECKDB is:

"CHECKDB found 0 allocation errors and 1 consistency errors in table
'sysdepends' (object ID 12)."

Any suggestions?


/Angelo
 
Hi Angelo,

Open Query Analyzer and try this.
----
USE master
GO
ALTER DATABASE YourDatabase
SET SINGLE_USER
GO

USE YourDatabase
GO

DBCC CHECKTABLE('sysdepends',REPAIR_REBUILD )

USE master
GO
ALTER DATABASE YourDatabase
SET MULTI_USER
----

If you don't resolve, ask your question in
( visto che il tuo nome sembra Italiano puoi chiedere su
)

bye
 
Hi Giorgio

Grazie per la risposta/Thanks for your reply.
Unfortunately I get this as result:

Server: Msg 2594, Level 16, State 1, Line 2
Invalid index ID (0) specified.
Server: Msg 2511, Level 16, State 1, Line 2
Table error: Object ID 12, Index ID 0. Keys out of order on page (1:304413),
slots 27 and 28.
DBCC results for 'sysdepends'.
Could not repair this error.
There are 1158194 rows in 5365 pages for object 'sysdepends'.
CHECKTABLE found 0 allocation errors and 1 consistency errors in table
'sysdepends' (object ID 12).
repair_rebuild is the minimum repair level for the errors found by DBCC
CHECKTABLE (is4.dbo.sysdepends repair_rebuild).

The main problem is "Could not repair this error" anf it worries me a lot. I
don't want to try with more "destructive" methods because I'm afraid to lose
the 21 Gbyte database.
In this case I have to rely on you for the possible solution...

Ciao
Angelo



giorgio rancati said:
Hi Angelo,

Open Query Analyzer and try this.
----
USE master
GO
ALTER DATABASE YourDatabase
SET SINGLE_USER
GO

USE YourDatabase
GO

DBCC CHECKTABLE('sysdepends',REPAIR_REBUILD )

USE master
GO
ALTER DATABASE YourDatabase
SET MULTI_USER
----

If you don't resolve, ask your question in
( visto che il tuo nome sembra Italiano puoi chiedere su
)

bye
--
Giorgio Rancati
[Office Access MVP]

Angelo Brusati said:
I've tried to follow any kind of tips for the solution og this problem, but
I cannot use the repair tools because of the system table "sysdepends".
What can I do? The regular integrity check, database and transaction log
backups fail every single day!

The error, according to CHECKDB is:

"CHECKDB found 0 allocation errors and 1 consistency errors in table
'sysdepends' (object ID 12)."

Any suggestions?


/Angelo
Click to expand...
Click to expand...
 
The problem is apparently an index on sysdepends (there are two og them:
custered and non-clustered).
Unfortunately, I cannot drop the indexes because they're system indexes.

Some other suggestions?

Thanks again

/Angelo


Angelo Brusati said:
Hi Giorgio

Grazie per la risposta/Thanks for your reply.
Unfortunately I get this as result:

Server: Msg 2594, Level 16, State 1, Line 2
Invalid index ID (0) specified.
Server: Msg 2511, Level 16, State 1, Line 2
Table error: Object ID 12, Index ID 0. Keys out of order on page
(1:304413), slots 27 and 28.
DBCC results for 'sysdepends'.
Could not repair this error.
There are 1158194 rows in 5365 pages for object 'sysdepends'.
CHECKTABLE found 0 allocation errors and 1 consistency errors in table
'sysdepends' (object ID 12).
repair_rebuild is the minimum repair level for the errors found by DBCC
CHECKTABLE (is4.dbo.sysdepends repair_rebuild).

The main problem is "Could not repair this error" anf it worries me a lot.
I don't want to try with more "destructive" methods because I'm afraid to
lose the 21 Gbyte database.
In this case I have to rely on you for the possible solution...

Ciao
Angelo



giorgio rancati said:
Hi Angelo,

Open Query Analyzer and try this.
----
USE master
GO
ALTER DATABASE YourDatabase
SET SINGLE_USER
GO

USE YourDatabase
GO

DBCC CHECKTABLE('sysdepends',REPAIR_REBUILD )

USE master
GO
ALTER DATABASE YourDatabase
SET MULTI_USER
----

If you don't resolve, ask your question in
( visto che il tuo nome sembra Italiano puoi chiedere su
)

bye
--
Giorgio Rancati
[Office Access MVP]

Angelo Brusati said:
I've tried to follow any kind of tips for the solution og this problem, but
I cannot use the repair tools because of the system table "sysdepends".
What can I do? The regular integrity check, database and transaction log
backups fail every single day!

The error, according to CHECKDB is:

"CHECKDB found 0 allocation errors and 1 consistency errors in table
'sysdepends' (object ID 12)."

Any suggestions?


/Angelo
Click to expand...
Click to expand...
Click to expand...
 
Hi,

joel-ange sitbon has invited you to join GreenZap and get $50 WebCash to
spend online. Sign up for a FREE GreenZap account and get $50 to spend at
hundreds of the world's premier merchants, many of whom are offering
incredible upfront discounts. Click on the link below to go to GreenZap and
signup! All thanks to joel-ange sitbon.

It's Zappening in the GreenZap Storez.
http://www.greenzap.com/joel1962

If you do not want to receive these emails in the future click the link
below:
http://www.greenzap.com/optout_invite.asp


Angelo Brusati said:
Hi Giorgio

Grazie per la risposta/Thanks for your reply.
Unfortunately I get this as result:

Server: Msg 2594, Level 16, State 1, Line 2
Invalid index ID (0) specified.
Server: Msg 2511, Level 16, State 1, Line 2
Table error: Object ID 12, Index ID 0. Keys out of order on page
(1:304413), slots 27 and 28.
DBCC results for 'sysdepends'.
Could not repair this error.
There are 1158194 rows in 5365 pages for object 'sysdepends'.
CHECKTABLE found 0 allocation errors and 1 consistency errors in table
'sysdepends' (object ID 12).
repair_rebuild is the minimum repair level for the errors found by DBCC
CHECKTABLE (is4.dbo.sysdepends repair_rebuild).

The main problem is "Could not repair this error" anf it worries me a lot.
I don't want to try with more "destructive" methods because I'm afraid to
lose the 21 Gbyte database.
In this case I have to rely on you for the possible solution...

Ciao
Angelo



giorgio rancati said:
Hi Angelo,

Open Query Analyzer and try this.
----
USE master
GO
ALTER DATABASE YourDatabase
SET SINGLE_USER
GO

USE YourDatabase
GO

DBCC CHECKTABLE('sysdepends',REPAIR_REBUILD )

USE master
GO
ALTER DATABASE YourDatabase
SET MULTI_USER
----

If you don't resolve, ask your question in
( visto che il tuo nome sembra Italiano puoi chiedere su
)

bye
--
Giorgio Rancati
[Office Access MVP]

Angelo Brusati said:
I've tried to follow any kind of tips for the solution og this problem, but
I cannot use the repair tools because of the system table "sysdepends".
What can I do? The regular integrity check, database and transaction log
backups fail every single day!

The error, according to CHECKDB is:

"CHECKDB found 0 allocation errors and 1 consistency errors in table
'sysdepends' (object ID 12)."

Any suggestions?


/Angelo
Click to expand...
Click to expand...
Click to expand...
 
Friend,

joel-ange sitbon has invited you to join GreenZap and get $50 WebCash to
spend online. Sign up for a FREE GreenZap account and get $50 to spend at
hundreds of the world's premier merchants, many of whom are offering
incredible upfront discounts. Click on the link below to go to GreenZap and
signup! All thanks to joel-ange sitbon.

It's Zappening in the GreenZap Storez.
http://www.greenzap.com/joel1962

If you do not want to receive these emails in the future click the link
below:
http://www.greenzap.com/optout_invite.asp


Angelo Brusati said:
Hi Giorgio

Grazie per la risposta/Thanks for your reply.
Unfortunately I get this as result:

Server: Msg 2594, Level 16, State 1, Line 2
Invalid index ID (0) specified.
Server: Msg 2511, Level 16, State 1, Line 2
Table error: Object ID 12, Index ID 0. Keys out of order on page
(1:304413), slots 27 and 28.
DBCC results for 'sysdepends'.
Could not repair this error.
There are 1158194 rows in 5365 pages for object 'sysdepends'.
CHECKTABLE found 0 allocation errors and 1 consistency errors in table
'sysdepends' (object ID 12).
repair_rebuild is the minimum repair level for the errors found by DBCC
CHECKTABLE (is4.dbo.sysdepends repair_rebuild).

The main problem is "Could not repair this error" anf it worries me a lot.
I don't want to try with more "destructive" methods because I'm afraid to
lose the 21 Gbyte database.
In this case I have to rely on you for the possible solution...

Ciao
Angelo



giorgio rancati said:
Hi Angelo,

Open Query Analyzer and try this.
----
USE master
GO
ALTER DATABASE YourDatabase
SET SINGLE_USER
GO

USE YourDatabase
GO

DBCC CHECKTABLE('sysdepends',REPAIR_REBUILD )

USE master
GO
ALTER DATABASE YourDatabase
SET MULTI_USER
----

If you don't resolve, ask your question in
( visto che il tuo nome sembra Italiano puoi chiedere su
)

bye
--
Giorgio Rancati
[Office Access MVP]

Angelo Brusati said:
I've tried to follow any kind of tips for the solution og this problem, but
I cannot use the repair tools because of the system table "sysdepends".
What can I do? The regular integrity check, database and transaction log
backups fail every single day!

The error, according to CHECKDB is:

"CHECKDB found 0 allocation errors and 1 consistency errors in table
'sysdepends' (object ID 12)."

Any suggestions?


/Angelo
Click to expand...
Click to expand...
Click to expand...
 
Giorgio,

Great, you're the man!
Undocumented Stored Procedure... typical...
It actually solved the problem.

Grazie infinite, senza il tuo tip non sarei riuscito a trovare
quell'articolo da solo!

/Angelo

giorgio rancati said:
Hi Angelo,

view this Kb
----
HOW TO: Use the sp_fixindex Stored Procedure
http://support.microsoft.com/kb/106122/en-us
----

bye
--
Giorgio Rancati
[Office Access MVP]

Angelo Brusati said:
The problem is apparently an index on sysdepends (there are two og them:
custered and non-clustered).
Unfortunately, I cannot drop the indexes because they're system indexes.

Some other suggestions?

Thanks again

/Angelo
Click to expand...
Click to expand...
 
Back
Top