Home All Groups Group Topic Archive Search About

CHECKDB finds consistency errors in table 'sysdepends'

Author
20 Dec 2005 12:27 PM
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)."
(SQL 2000 SP3)

Any suggestions?


/Angelo

Author
20 Dec 2005 6:46 PM
Tibor Karaszi
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp

Show quote
"Angelo Brusati" <ang***@intrasuite.net> wrote in message
news:unfjPEWBGHA.4076@TK2MSFTNGP14.phx.gbl...
> 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)."
> (SQL 2000 SP3)
>
> Any suggestions?
>
>
> /Angelo
>
>
>
Author
21 Dec 2005 8:46 AM
Angelo Brusati
Tibor, thanks for your answer.
But has the article of your link something to do with my problem?
The database is not suspect and the hardware is OK, as well as the disks.

/Angelo


Show quote
"Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in
message news:eja3qWZBGHA.272@TK2MSFTNGP09.phx.gbl...
> http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
>
> "Angelo Brusati" <ang***@intrasuite.net> wrote in message
> news:unfjPEWBGHA.4076@TK2MSFTNGP14.phx.gbl...
>> 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)."
>> (SQL 2000 SP3)
>>
>> Any suggestions?
>>
>>
>> /Angelo
>>
>>
>>
>
Author
21 Dec 2005 9:43 AM
Tibor Karaszi
The DBCC message states that you have a corruption in your database. So the database isn't suspect,
but you still have a corruption in the database.

Show quote
"Angelo Brusati" <ang***@intrasuite.net> wrote in message
news:%23u%231PugBGHA.3984@TK2MSFTNGP14.phx.gbl...
> Tibor, thanks for your answer.
> But has the article of your link something to do with my problem?
> The database is not suspect and the hardware is OK, as well as the disks.
>
> /Angelo
>
>
> "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message
> news:eja3qWZBGHA.272@TK2MSFTNGP09.phx.gbl...
>> http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>>
>> "Angelo Brusati" <ang***@intrasuite.net> wrote in message
>> news:unfjPEWBGHA.4076@TK2MSFTNGP14.phx.gbl...
>>> 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)."
>>> (SQL 2000 SP3)
>>>
>>> Any suggestions?
>>>
>>>
>>> /Angelo
>>>
>>>
>>>
>>
>
>

AddThis Social Bookmark Button