Re: What is going on??? Error 834, Severity 24, State:1etc
From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 06/08/04
- Next message: Carsten Holm: "Problem with large transactionfile."
- Previous message: Marco Broenink: "Problem report xp_MSADEnabled"
- In reply to: armin: "What is going on??? Error 834, Severity 24, State:1etc"
- Next in thread: armin: "Re: What is going on??? Error 834, Severity 24, State:1etc"
- Reply: armin: "Re: What is going on??? Error 834, Severity 24, State:1etc"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 8 Jun 2004 08:14:34 -0400
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: Carsten Holm: "Problem with large transactionfile."
- Previous message: Marco Broenink: "Problem report xp_MSADEnabled"
- In reply to: armin: "What is going on??? Error 834, Severity 24, State:1etc"
- Next in thread: armin: "Re: What is going on??? Error 834, Severity 24, State:1etc"
- Reply: armin: "Re: What is going on??? Error 834, Severity 24, State:1etc"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
