DBCC CHECKDB

We have a number of databases where we are getting
consistency errors when we run DBCC CHECKDB. A sample
error is as follows:
Table error: Object ID 1961774046, index ID 0, page
(1:11920), row 1. Record check (Valid SqlVariant) failed.
Values are 4 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 1961774046, index ID 0, page
(1:11920), row 2. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed.
Values are 17 and 5.
.
CHECKDB found 0 allocation errors and 15011 consistency
errors in table 'SurveyDataElement' (object ID
1961774046).
We can't use any of the fix options as this results in
considerable data loss. Restoring backups is not an
option.
The problem itself also seems to be inconsistent. If we
detach the problem database and then attach it on another
server, running DBCC gives us error messages but for
different tables.
Any help would be seriously appreciated.
MartinFurther to previous post:
SQL Server 2000 SP3|||Martin,
If you can't restore from a backup then you don't have many options other
than to do some type of repair. This may indeed result in data loss but
that is why it is so important to do regular backups and DBCC's to catch
these types of issues before they get to this stage. I suggest you give MS
PSS a call and see if there is anything they can do as your options are now
limited.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
--
Andrew J. Kelly
SQL Server MVP
"MartinMcD" <MMcDonnell@.dial.pipex.com> wrote in message
news:01b801c379d5$d64c5eb0$a001280a@.phx.gbl...
> We have a number of databases where we are getting
> consistency errors when we run DBCC CHECKDB. A sample
> error is as follows:
> Table error: Object ID 1961774046, index ID 0, page
> (1:11920), row 1. Record check (Valid SqlVariant) failed.
> Values are 4 and 0.
> Server: Msg 2537, Level 16, State 1, Line 1
> Table error: Object ID 1961774046, index ID 0, page
> (1:11920), row 2. Record check (innerLength <=> innerColInfo.CbMaxLen () && innerPCol != NULL) failed.
> Values are 17 and 5.
> .
> CHECKDB found 0 allocation errors and 15011 consistency
> errors in table 'SurveyDataElement' (object ID
> 1961774046).
> We can't use any of the fix options as this results in
> considerable data loss. Restoring backups is not an
> option.
> The problem itself also seems to be inconsistent. If we
> detach the problem database and then attach it on another
> server, running DBCC gives us error messages but for
> different tables.
> Any help would be seriously appreciated.
> Martin|||Andrew,
Thanks for the reply, we'll try PSS and we do have some backups - it
will just take days to sort through them.
Any idea what might cause there errors as one of the databases was
only built a week or so ago whilst others have been around for months?
I also don't understand why the same database gives different checkdb
results when attached to different servers. I am concerned that we
avoid these problems in future but as its happened on over 50% of our
databases I don't have a great deal of faith that it won't.
Martin
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote:
>Martin,
>
>If you can't restore from a backup then you don't have many options other
>than to do some type of repair. This may indeed result in data loss but
>that is why it is so important to do regular backups and DBCC's to catch
>these types of issues before they get to this stage. I suggest you give MS
>PSS a call and see if there is anything they can do as your options are now
>limited.
>http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
>http://www.mssqlserver.com/faq/general-pss.asp MS PSS