October 10, 2005 at 6:25 am
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.
October 11, 2005 at 4:05 am
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
October 11, 2005 at 5:52 am
Already did so, the error persists. I am wondering if there are any crack/hack type tools to correct allocation errors?
October 11, 2005 at 7:57 am
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 ! ).
October 11, 2005 at 8:09 am
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.
October 11, 2005 at 8:14 am
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.
October 12, 2005 at 3:25 am
I am not sure, what is PSS? What is their web address?
October 12, 2005 at 2:48 pm
PSS stands for Product Support Services.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply