What is going on??? Error 834, Severity 24, State:1etc

From: armin (arminmu_at_lsinter.net)
Date: 06/08/04


Date: Tue, 8 Jun 2004 04:57:52 -0700

Please help, I'm becoming desperate...
SQL Server 7.0, running on NT.

In the morning, when user try to query one table, I'm
always receiving following errors:

Error 834, Severity 24, State:1
I/O error (bad page ID) detected during read of BUF
pointer = 0x12af6400, page ptr = 0x72950000, pageid =
(0x1:0x182e80), dbid = 8, status = 0x801, file = x:\MSSQL7
\data\xxxx_xxxx.MDF..

dbcc checkdb gives me some consistency errors only on that
single tables, there is no any errors reported in the erst
of database.
That table is being filled up, by one nightly job, so I'm
still able to drop that table, recreate it and fill it,
afterwards dbcc checkdb doesn't report any error, and
everything's fine till next morning, and then the same
story, over and over again...

During the night, job truncates this table then fill it
with the same stored procedure with which I fill the table
in the morning. The only difference between night job and
morning manually actions is that in the morning I drop and
recreate the table, while the night job truncate and then
fill it up.

Tape backup is done with ArcServe, and in the time when
the mentioned sql server job runs, ArcServer BAOF is
backing up datafile of database in question. Can truncate
on a table while ArcServe is backing datafile up to tape
damage that table???

Please Help!!!!!
Thanks!!!!!!!!!!


Loading