Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

I/O error (bad page ID) detected during read of BUF pointer Expand / Collapse
Author
Message
Posted Monday, October 10, 2005 6:25 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 6:51 PM
Points: 987, Visits: 1,631

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. 




Post #227579
Posted Tuesday, October 11, 2005 4:05 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 23, 2007 4:05 AM
Points: 97, 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

Post #227878
Posted Tuesday, October 11, 2005 5:52 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 6:51 PM
Points: 987, Visits: 1,631
Already did so, the error persists.  I am wondering if there are any crack/hack type tools to correct allocation errors?


Post #227898
Posted Tuesday, October 11, 2005 7:57 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 23, 2007 4:05 AM
Points: 97, 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 ! ).
Post #227944
Posted Tuesday, October 11, 2005 8:09 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:31 PM
Points: 33,051, Visits: 15,159
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
Post #227948
Posted Tuesday, October 11, 2005 8:14 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 23, 2007 4:05 AM
Points: 97, 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.
Post #227953
Posted Wednesday, October 12, 2005 3:25 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 6:51 PM
Points: 987, Visits: 1,631
I am not sure, what is PSS?  What is their web address?


Post #228213
Posted Wednesday, October 12, 2005 2:48 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 4, 2008 1:16 PM
Points: 44, Visits: 2

PSS stands for Product Support Services. 

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




Post #228457
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse