Restoring from a database backup should always be considered the primary means of fixing a damaged database. Robert Lis Jul 23 '05 #2 P: n/a Erland Sommarskog Robert-SoftMAR (firstname.lastname@example.org) writes: How i can repair database ms-sql when attach file i have: error 823 I/O error (bad page ID) to WeP Peripherals Ltd w.e.f August 2002. You cannot edit your own events. http://renderq.net/i-o/i-o-error-bad-page-id-detected-during-read-at.php
If you don't have a backup or if the errors detected are very isolated, the repair functionality of DBCC CHECKDB may be useful. Moore \(Strider\) "Robert-SoftMAR"
How i can repair database ms-sql when attach file i have: error 823 I/O error (bad page ID) detected during read at offset 0x itd... You cannot delete other posts. gkrishn New Member Hello Guys,after a short break I am back(Hmm with some issues in hand  )
I got I/O error on one table whenever do You cannot post events.
You cannot edit other posts. If DBCC printed error messages, contact your system administrator.*/dbcc dbreindex('C41') /*Server: Msg 823, Level 24, State 2, Line 1I/O error (bad page ID) detected during read at offset 0x00000002100000 in file Then if you need to run DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS you've got something to fall back on. The primary key will have an index name associated with it whose size you can find out, you can find the index name by running sp_help tblDC_AccumulatorQualities thomas, May 10, 2006
Thursday, April 17, 2008 6:12 AM Reply | Quote Moderator 0 Sign in to vote Although you can run dbcc checkdb with repair_allow_data_loss, I would suggest you read through Paul's article Dbcc Checkdb SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! gkrishn, May 9, 2006 #2 satya Moderator BOL provides Message Text I/O error %ls detected during %S_MSG at offset %#016I64x in file '%ls'. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/88943bb5-1d86-444b-83ba-23952ac4e785/io-error-bad-page-id?forum=sqldatabaseengine What should i do to recover my database?
Reply With Quote 01-18-2008,12:43 PM #2 skhanal View Profile View Forum Posts Experts Join Date Nov 2002 Location New Jersey, USA Posts 3,896 This might help http://support.microsoft.com/kb/828339 Reply With Quote Quick Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. And I don't have any backup of DB. Mast_dba, May 9, 2006 #2 satya Moderator The message is clear the index is corrupted and in order to avoid further mismatch of indexes/data (sometimes) it is better to fix the
Jul 23 '05 #5 P: n/a Robert-SoftMAR Yes, I now this massage in Books Online but i can't do: DBCC CHECKDB beacouse i have error: Could not locate entry in sysdatabases http://www.dbforums.com/showthread.php?1118746-error-I-O-error-(bad-page-ID)-detected-during-read-at-offset-0x000001ad65a000 I would even try to rebuild, not sure what to do or if anything is even possible. Error 823 Severity 24 State 2 Matthew Floyd replied Mar 11, 2003 Same thing happened to me. Here's an old blogpost I did while back in the Storage Engine team at MS - this may help you too.
No entry found with that name. this contact form You cannot delete your own posts. That's a drag, isn't it?! Your response is highly appreciated.
However, using DBCC CHECKDB can be more time consuming than restoring the damaged files from a backup, and you may not be able to recover all your data. Forgot your password? The time now is 13:30. http://renderq.net/i-o/i-o-error-bad-page-id-detected-during.php Log in :: Register :: Not logged in Home Tags Articles Editorials Stairways Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact
Is there any way to resolve this issue ? Make sure that the name is entered correctly. Anyone want to advise or work with me to see if the data can be read and pieced back together?John Post #422315 Paul RandalPaul Randal Posted Wednesday, November 14, 2007 2:43
You cannot delete other topics. Post your question and get tips & solutions from a community of 418,570 IT Pros & Developers. bad page ID P: n/a Robert-SoftMAR How i can repair database ms-sql when attach file i have: error 823 I/O error (bad page ID) detected during read at offset 0x itd... If you don't have a backup or if the errors detected are very isolated, the repair functionality of DBCC CHECKDB may be useful.
gkrishn, May 9, 2006 #2 thomas New Member As a precaution try creating a copy of the table and copying all the data out of it into the copy (if you No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers PCMag Digital Group AdChoices unused Home Articles Tips FAQ Books Software SQL Server Scripts Forum   Log in or Sign up SQL Server Performance Forums Home Forums > ARCHIVED SQL Server Check This Out You may download attachments.
You cannot post IFCode. Caution If running DBCC CHECKDB with one of the repair clauses does not correct the problem or if you are unsure how this process may affect your data, contact your primary