Re: What is going on??? Error 834, Severity 24, State:1etc
From: armin (anonymous_at_discussions.microsoft.com)
Date: 06/08/04
- Next message: Eric.Li: "Re: hardware recommendation"
- Previous message: Mark Allison: "Re: Port Blocking"
- In reply to: Wayne Snyder: "Re: What is going on??? Error 834, Severity 24, State:1etc"
- Next in thread: Michael Abraham: "Re: What is going on??? Error 834, Severity 24, State:1etc"
- Reply: Michael Abraham: "Re: What is going on??? Error 834, Severity 24, State:1etc"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 8 Jun 2004 05:29:39 -0700
Thank you very much for answer, Wayne.
The strange thing is that this complete procedure is
running for almost two years now. And the strangest is
that dbcccheckdb always gives consistency errors only on
that table which is truncated and refilled during the
night... HW specialists says that there is no any errors
hw related. I forgot to mention that this "thing" happened
on two servers before this one, this is the third. I
restarted two previous servers, afterwards these "thing"
didn't apperar (till now).
Any fresh idea?
BR
Armin
>-----Original Message-----
>Truncating the table while another processis running
should NOT corrupt the
>table....
>
>Make sure you are up to date on service packs..
>
>The best liklihood is that you are seeing some hardware
errors related to
>heavy loading during the batch process...
>
>If you can not find any hardware issues, perhaps you
should open a call to
>PSS.
>
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>
>"armin" <arminmu@lsinter.net> wrote in message
>news:1975101c44d4f$d3bcd6e0$a301280a@phx.gbl...
>> 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!!!!!!!!!!
>
>
>.
>
- Next message: Eric.Li: "Re: hardware recommendation"
- Previous message: Mark Allison: "Re: Port Blocking"
- In reply to: Wayne Snyder: "Re: What is going on??? Error 834, Severity 24, State:1etc"
- Next in thread: Michael Abraham: "Re: What is going on??? Error 834, Severity 24, State:1etc"
- Reply: Michael Abraham: "Re: What is going on??? Error 834, Severity 24, State:1etc"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
