SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


I/O error (bad page ID) detected during read of BUF pointer


I/O error (bad page ID) detected during read of BUF pointer

Author
Message
Roust_m
Roust_m
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3636 Visits: 1981

Hi!

I had a database in suspect mode (MS SQL 7.0, sp3), that I managed to bring online, but if I try to query more more than 705931 records out of 1295837 in one of the tables, I get this error message:


Server: Msg 823, Level 24, State 1, Line 1
I/O error (bad page ID) detected during read of BUF pointer = 0x14362f80, page ptr = 0x4bb3c000, pageid = (0x1:0xab9f), dbid = 13, status = 0x801, file = E:\mydb_Data.MDF.
Connection Broken

Oracle has a trace flag that can automatically skip the bad blocks to allow to recover as much data as possible. Is there such flag in MS SQL?

Thanks.





Derek Wallace
Derek Wallace
Old Hand
Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)

Group: General Forum Members
Points: 343 Visits: 1

Hi, Look up dbcc checkdb on books on line. I suggest dbcc checkdb(database, repair_rebuild) with ALL_ERRORMSGS. Also run a dbcc checktable ( tablename ). I know with Torn Page detected on a suspect database you really have no option but to restore the last good backup. In the error you have got try the above commands and see how you get on.

Rgds

Derek


Roust_m
Roust_m
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3636 Visits: 1981
Already did so, the error persists. I am wondering if there are any crack/hack type tools to correct allocation errors?



Derek Wallace
Derek Wallace
Old Hand
Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)

Group: General Forum Members
Points: 343 Visits: 1
Hi again. Once the mdf is corrupt unless dbcc checkdb or dbcc cleantable can fix the coruption you will have to restore. And before so, rectify the hard disk issue. I had a corrupt db recently and not only had to restore, but had replace the disk controller and rebuild replication !!!! ( which was worse from a business point of view.. another story ! ).
Steve Jones
Steve Jones
SSC Guru
SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)SSC Guru (147K reputation)

Group: Administrators
Points: 147429 Visits: 19434
Usually if you call PSS, they have tools that can help. I've had corrupt tables and you can try to BCP out the data and then drop and rebuild the table,but if some pages are corrupt, the BCP will fail.

They have had me BCP out around the error(find out which pages error out, BCP based on criteria, i.e. PK, around them), and then have helped me use DBCC page or other tools to read back the data from the corrupt pages.

If you really need the data back or this is important Data, call PSS.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Derek Wallace
Derek Wallace
Old Hand
Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)Old Hand (343 reputation)

Group: General Forum Members
Points: 343 Visits: 1
Hi Steve, I never thought of BCP'ing out the data. But as you say if the data is that important, its worth a try. I reckon it will be hairy enough a task. I'll take your reply on board for myself for furture reference. Thanks , Derek.
Roust_m
Roust_m
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3636 Visits: 1981
I am not sure, what is PSS? What is their web address?



jasonhatfield01
jasonhatfield01
SSC-Enthusiastic
SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)

Group: General Forum Members
Points: 122 Visits: 2

PSS stands for Product Support Services.

http://support.microsoft.com/default.aspx





Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search