What should i do to recover my database? Refer the link http://msdn2.microsoft.com/en-us/library/ms176064.aspx for more. in file "......." sodeep Flowing Fount of Yak Knowledge USA 7174 Posts Posted-03/10/2009: 11:32:48 http://support.microsoft.com/kb/828339 paulrandal Yak with Vast SQL Skills USA 899 Posts Posted-03/10/2009: 13:25:37 Solved I/O error (bad page ID): cannot recover. Source
You cannot delete other events. Posted on 2006-10-23 MS SQL Server 1 Verified Solution 5 Comments 611 Views Last Modified: 2011-10-03 Hi guys, The SQL server was restarted this morning and three databases didn't start up If the page has different rows, then you need to work out which rows are missing in the main database and then see if any of those rows exist in the 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
I would even try to rebuild, not sure what to do or if anything is even possible. The following set of activities have been run with the following results. To start viewing messages, select the forum that you want to visit from the selection below.
You cannot post events. Monday, April 07, 2008 3:55 AM Reply | Quote Moderator 0 Sign in to vote Have you tried repair option?? Error message says about Index ID 0 and Index ID 1 . You cannot post topic replies.
And you know what your mother told you about using four letter words! Dbcc Checkdb This article will help you to understand Proxy and when it is useful. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? Join & Ask a Question Need Help in Real-Time?
You cannot rate topics. Click Here to join Tek-Tips and talk with other members! All repair did would have been to deallocate the page (I'm guessing as you didn't post the full list of errors)(To anyone that's going to suggest using a log analysis or All Forums General SQL Server Forums Data Corruption Issues I/O error (bad page ID) detected during read at...
You cannot vote within polls. http://www.tek-tips.com/viewthread.cfm?qid=1018405 Restoring from a database backup should always be considered the primary means of fixing a damaged database. Error 823 Severity 24 State 2 The page that had the 823 error cannot be read by the operating system - that data is gone. The low key value on page (1:3574461) (level 0) is not >= the key value in the parent (1:3185 slot 112.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0
You're now being signed in. All product names are trademarks of their respective companies. Please help me out Reply With Quote 08-25-03,08:36 #2 dbadelphes View Profile View Forum Posts Registered User Join Date Feb 2003 Location Montreal, Canada Posts 117 Re: I/O error (bad page Our new SQL Server Forums are live!
You may download attachments. Toolbox.com is not affiliated with or endorsed by any company listed at this site. See the SQL Server errorlog for details."running dbcc checkdb ('200') in the query analyzer gives the same message.In the log files I see: "I/O error (bad page ID) detected during read have a peek here Report Abuse.
SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! You cannot edit your own posts. thomas, May 9, 2006 #2 gkrishn New Member Thanks Thomas .But my record is more than 7 CRORE .
The time now is 22:01. 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 Username: Password: Save Password Forgot your Password? Will Primary key index(clustered) will occupy space on disk?See the scenario >exec sp_spaceused PK_tblDC_AccumulatorQualities Server: Msg 15064, Level 11, State 1, Procedure sp_spaceused, Line 96 PRIMARY KEY and UNIQUE KEY constraints
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 . http://blogs.msdn.com/sqlserverstorageengine/archive/2007/01/18/fixing-damaged-pages-using-page-restore-or-manual-inserts.aspxLet me know how you get on. You cannot edit other topics. How coud we recover the data from our MDF-LDF?
Server Windows 2003 using SCSI RAIS array of discs. Join Us! *Tek-Tips's functionality depends on members receiving e-mail. The database is marked suspect and I can only choose for detach or take off line.The biggest problem is that using dbcc checkdb it gives me the previous mentioned error message. Thanks,John Post #422347 Paul RandalPaul Randal Posted Wednesday, November 14, 2007 3:24 PM SSCrazy Group: General Forum Members Last Login: Wednesday, October 12, 2016 9:27 AM Points: 2,053, Visits: 1,712 No
Your name or email address: Do you already have an account? Last edited by rdjabarov; 02-24-05 at 22:35. "The data in a record depends on the Key to the record, the Whole Key, and nothing but the Key, so help me Codd." All rights reserved. Register now while it's still free!
Catadmin - MCDBA, MCSARemember, "Work" is a four letter word. Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud
Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Then if you need to run DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS you've got something to fall back on. http://support.microsoft.com/default.aspx 0 Write Comment First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Can you read the tables ?or it is did not became 'emergency Go to Solution 3 Comments LVL 42 Overall: Level 42 MS SQL Server 38 Message Active 1 day
Privacy statement © 2016 Microsoft.