Problems with dbcc checkdb

Hello,
i am a german beginner in handling SQL servers and please excuses my
english.
Here is my problem:
My SQL-Server (Windows 2000 SP3, SQL Server 2000 SP3) fools me. A querry
dbcc checkdb promotes first no errors. I repeat the querry: consistency
errors discovered. Then again, no more. Is such a behavior normal or points
it on a hard- or a software problem?
I am grateful for each assistance. Thank you.
Ralf PottIf your DB has been accessed in the same time when you where doing CHECKDB, such a behavior could be normal. If you not getting consitant errors in the same spot in DB.|||What are the errors being reported? It could be a transient or intermittent
hardware fault.
--
Paul Randal
DBCC Technical Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ralf Pott" <ralf.pott@.wmsteuer.de> wrote in message
news:bnoi2o$5m2$07$1@.news.t-online.com...
> Hello,
> i am a german beginner in handling SQL servers and please excuses my
> english.
> Here is my problem:
> My SQL-Server (Windows 2000 SP3, SQL Server 2000 SP3) fools me. A querry
> dbcc checkdb promotes first no errors. I repeat the querry: consistency
> errors discovered. Then again, no more. Is such a behavior normal or
points
> it on a hard- or a software problem?
> I am grateful for each assistance. Thank you.
> Ralf Pott
>
>
>
>
>|||"Paul S Randal [MS]" <prandal@.online.microsoft.com> schrieb im Newsbeitrag
news:utKIBwknDHA.1096@.TK2MSFTNGP11.phx.gbl...
> What are the errors being reported? It could be a transient or
intermittent
> hardware fault.
Hello,
ist look´s like
2003-10-29 10:35:14.85 spid96 DBCC CHECKDB (db_10it), ausgeführt von sa,
hat 0 Fehler gefunden und 0 Fehler behoben.
2003-10-29 11:12:59.87 spid96 DBCC CHECKDB (db_10it), ausgeführt von sa,
hat 2 Fehler gefunden und 0 Fehler behoben.
2003-10-29 11:24:39.73 spid96 DBCC CHECKDB (db_10it), ausgeführt von sa,
hat 0 Fehler gefunden und 0 Fehler behoben.
2003-10-29 11:35:28.03 spid96 DBCC CHECKDB (db_10it), ausgeführt von sa,
hat 1 Fehler gefunden und 0 Fehler behoben.
2003-10-29 11:40:31.71 spid96 DBCC CHECKDB (db_10it), ausgeführt von sa,
hat 1 Fehler gefunden und 0 Fehler behoben.
2003-10-29 14:25:43.51 spid65 DBCC CHECKDB (db_10it), ausgeführt von sa,
hat 0 Fehler gefunden und 0 Fehler behoben.
2003-10-29 14:29:32.99 spid65 DBCC CHECKDB (db_10it), ausgeführt von sa,
hat 1 Fehler gefunden und 0 Fehler behoben.
2003-10-29 14:33:41.21 spid65 DBCC CHECKDB (db_10it), ausgeführt von sa,
hat 2 Fehler gefunden und 0 Fehler behoben.
2003-10-29 14:37:37.81 spid65 DBCC CHECKDB (db_10it), ausgeführt von sa,
hat 0 Fehler gefunden und 0 Fehler behoben.
2003-10-30 07:22:31.85 spid53 DBCC CHECKDB (db_10it), ausgeführt von sa,
hat 7 Fehler gefunden und 0 Fehler behoben.
2003-10-30 07:30:10.42 spid53 DBCC CHECKDB (db_10it), ausgeführt von sa,
hat 7 Fehler gefunden und 0 Fehler behoben.
The Querry Analyzer reported most:
Server: Nachr.-Nr. 2511, Schweregrad 16, Status 2, Zeile 1
Tabellenfehler: Objekt-ID 619773911, Index-ID 0. Falsche
Schlüsselreihenfolge auf Seite (1:147881), Slots 58 und 59.
I hope, that this is helpful.
Ralf Pott|||You've got out-of-order keys on an index page. Is there a lot of activity on
this index? Is it always the same page that has the problem reported on it?
--
Paul Randal
DBCC Technical Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ralf Pott" <ralf.pott@.wmsteuer.de> wrote in message
news:bnqc5i$9ro$05$1@.news.t-online.com...
> "Paul S Randal [MS]" <prandal@.online.microsoft.com> schrieb im Newsbeitrag
> news:utKIBwknDHA.1096@.TK2MSFTNGP11.phx.gbl...
> > What are the errors being reported? It could be a transient or
> intermittent
> > hardware fault.
>
> Hello,
> ist look´s like
> 2003-10-29 10:35:14.85 spid96 DBCC CHECKDB (db_10it), ausgeführt von
sa,
> hat 0 Fehler gefunden und 0 Fehler behoben.
> 2003-10-29 11:12:59.87 spid96 DBCC CHECKDB (db_10it), ausgeführt von
sa,
> hat 2 Fehler gefunden und 0 Fehler behoben.
> 2003-10-29 11:24:39.73 spid96 DBCC CHECKDB (db_10it), ausgeführt von
sa,
> hat 0 Fehler gefunden und 0 Fehler behoben.
> 2003-10-29 11:35:28.03 spid96 DBCC CHECKDB (db_10it), ausgeführt von
sa,
> hat 1 Fehler gefunden und 0 Fehler behoben.
> 2003-10-29 11:40:31.71 spid96 DBCC CHECKDB (db_10it), ausgeführt von
sa,
> hat 1 Fehler gefunden und 0 Fehler behoben.
> 2003-10-29 14:25:43.51 spid65 DBCC CHECKDB (db_10it), ausgeführt von
sa,
> hat 0 Fehler gefunden und 0 Fehler behoben.
> 2003-10-29 14:29:32.99 spid65 DBCC CHECKDB (db_10it), ausgeführt von
sa,
> hat 1 Fehler gefunden und 0 Fehler behoben.
> 2003-10-29 14:33:41.21 spid65 DBCC CHECKDB (db_10it), ausgeführt von
sa,
> hat 2 Fehler gefunden und 0 Fehler behoben.
> 2003-10-29 14:37:37.81 spid65 DBCC CHECKDB (db_10it), ausgeführt von
sa,
> hat 0 Fehler gefunden und 0 Fehler behoben.
> 2003-10-30 07:22:31.85 spid53 DBCC CHECKDB (db_10it), ausgeführt von
sa,
> hat 7 Fehler gefunden und 0 Fehler behoben.
> 2003-10-30 07:30:10.42 spid53 DBCC CHECKDB (db_10it), ausgeführt von
sa,
> hat 7 Fehler gefunden und 0 Fehler behoben.
>
> The Querry Analyzer reported most:
> Server: Nachr.-Nr. 2511, Schweregrad 16, Status 2, Zeile 1
> Tabellenfehler: Objekt-ID 619773911, Index-ID 0. Falsche
> Schlüsselreihenfolge auf Seite (1:147881), Slots 58 und 59.
> I hope, that this is helpful.
>
> Ralf Pott
>
>|||"Paul S Randal [MS]" <prandal@.online.microsoft.com> schrieb im Newsbeitrag
news:uqiczeznDHA.744@.tk2msftngp13.phx.gbl...
> You've got out-of-order keys on an index page. Is there a lot of activity
on
> this index? Is it always the same page that has the problem reported on
it?
>
Yes, there is a lot of activity on this index, this is perhaps the most used
index. The database is used by a financial accounting programm. At the same
time 30 people works with this programm.
I think that the same page, maybe the same table reported the problem. The
producer of the program supplies a reorganization tool. This fails regularly
by the same table. Then the database can´t be used. The producer must repair
the database by hand. He says that one byte in the database was switched
from 1 to 0.
Is this maybe a hardware fault?
Ralf Pott|||Sounds like a hardware fault if it's on the same page. What do you mean by
reorganization tool? A tool that uses the inbuilt DBCC INDEXDEFRAG or DBCC
DBREINDEX command?
Have you run any hardware diagnostics on your IO subsystem? You can also
check the SQL Server and NT event logs for events indicating hardware
problems.
Regards,
Paul.
--
Paul Randal
DBCC Technical Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ralf Pott" <ralf.pott@.wmsteuer.de> wrote in message
news:bnt2c6$f21$07$1@.news.t-online.com...
> "Paul S Randal [MS]" <prandal@.online.microsoft.com> schrieb im Newsbeitrag
> news:uqiczeznDHA.744@.tk2msftngp13.phx.gbl...
> > You've got out-of-order keys on an index page. Is there a lot of
activity
> on
> > this index? Is it always the same page that has the problem reported on
> it?
> >
> Yes, there is a lot of activity on this index, this is perhaps the most
used
> index. The database is used by a financial accounting programm. At the
same
> time 30 people works with this programm.
> I think that the same page, maybe the same table reported the problem. The
> producer of the program supplies a reorganization tool. This fails
regularly
> by the same table. Then the database can´t be used. The producer must
repair
> the database by hand. He says that one byte in the database was switched
> from 1 to 0.
> Is this maybe a hardware fault?
> Ralf Pott
>|||"Paul S Randal [MS]" <prandal@.online.microsoft.com> schrieb im Newsbeitrag
news:uBDybHAoDHA.964@.TK2MSFTNGP10.phx.gbl...
> Sounds like a hardware fault if it's on the same page. What do you mean by
> reorganization tool? A tool that uses the inbuilt DBCC INDEXDEFRAG or DBCC
> DBREINDEX command?
>
Yes, I Think so.
> Have you run any hardware diagnostics on your IO subsystem? You can also
> check the SQL Server and NT event logs for events indicating hardware
> problems.
No. But I think also it is a hardware fault. I have tested the memeory and
it looks bad. I have ordered new one. Also I think that the harddisk
(IDE-RAID) make some trouble.
Thank you for everything.
Ralf Pott