You cannot send private messages. When we restored the db file, some part are only recovered and was located in other directory.Ex. I just checked my saved code and it was dbcc traceon(3604). When I tried to attached the recoverd db file I encountered an error: "Error 823: I/O error (bad page id) detected during read at offset 0x000000300 in the file
It means your disk drives are failing. All product names are trademarks of their respective companies. That's a drag, isn't it?! Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Database Groups Ask a New Question SQL Server The SQL Server group is a forum where http://www.sqlservercentral.com/Forums/Topic422315-265-1.aspx
Reply With Quote 02-24-05,22:32 #3 rdjabarov View Profile View Forum Posts Registered User Join Date Jul 2003 Location San Antonio, TX Posts 3,662 You should not have run with repair_allow_data_loss clause! You cannot post events. You cannot delete other events. I was trying to identify if I could read the actual data pages with using a dbcc traceon(3406) dbcc page('longshine,1,AnyPageNumber,1) in order to try to piece the data together but I
Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers healdem - 59 mark.b - 55 Pat Phelan - 54 ranman256 - 23 Can any one say what gone wrong here.It is Table or Index currupted? satya, May 10, 2006 #2 gkrishn New Member Also one more question. 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
You may have to register before you can post: click the register link above to proceed. Refer the link http://msdn2.microsoft.com/en-us/library/ms176064.aspx for more. The page that had the 823 error cannot be read by the operating system - that data is gone. https://support.microsoft.com/en-us/kb/826433 Be sure to check in the Windows System Event Log for disk errors, as you may have a bad controller or bad disk on this server.
Report Abuse. All Rights Reserved. All Forums General SQL Server Forums Data Corruption Issues I/O error (bad page ID) detected during read at... ll', Line 1]" After this we executed DBCC CHECKDB.
gkrishn, May 9, 2006 #2 gkrishn New Member Table 'tblDC_AccumulatorQualities' is causing trouble .Its a table with three columns and PRIMARY KEY on two of those columns. https://support.microsoft.com/en-us/kb/828339 Join this group Popular White Paper On This Topic Taking Business Intelligence to the Next Level 2Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be Error 823 Severity 24 State 2 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? Has anyone observed it on SQL 2005?
Forgot your password? It 's REPAIR_ALLOW_DATA_LOSS that will fix page allocation errors (which is what you have here). 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 satya, May 9, 2006 #2 gkrishn New Member Thnaks Satya !
and so on. Members Members Quick Links Registered Members Current Visitors Recent Activity Help Help Quick Links Smilies BB Codes Trophies Search titles only Posted by Member: Separate names with a comma. What should i do to recover my database? his comment is here You cannot vote within polls.
gkrishn, May 9, 2006 #2 Mast_dba New Member Just FYI all.... 7 CRORE = 70 Million Thanks MAST ITS IMPOSSIBLE TO DEFEAT A PERSON WHO NEVER GIVE UP. I would probably contact MS PSS -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de Heute schon gebloggt?http://www.insidesql.de/blogs Ich unterstuetze PASS Deutschland e.V. All you had to do was to drop constraints on the offending tables (you had ONLY 2, and they were spelled out both with names and object IDs!!!), drop indexes on If the hardware is not fixed, you may see this come up again and again.
So check the hardware issues and run diagnostics on the server, Consider using DBCC CHECKDB with the PHYSICAL_ONLY option to check the physical structure of the page and record headers. Saturday, April 05, 2008 5:22 AM Reply | Quote Moderator 0 Sign in to vote hardware problem has been resolved. still have inconsistency errors in several databases.. next step????? Is 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 weblink You may have to register before you can post: click the register link above to proceed.
I would even try to rebuild, not sure what to do or if anything is even possible. Restore damaged files from the latest database backup. 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 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
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 Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? You may download attachments. Forgot your password?
If you don't have a backup or if the errors detected are very isolated, the repair functionality of DBCC CHECKDB may be useful.