I O Error Bad Page Id Sql Server 2000
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by:
I/o Error (bad Page Id) Detected During Read At Offset
I/O error (bad page ID) SQL Server > SQL Server dbcc checkdb Database Engine Question 0 Sign in to vote getting the following errors on one of my databases.. MS SQL Server 2000 ENT edition (SP4) Trying to figure out how to handle this.. can anyone help???? I/O error (bad page ID) detected during read at offset 0x000000cee08000 in file and Error: 823, Severity: 24, State: 2 DBCC CHECKDB, DBCC CHECKCATALOG and DBCC CHECKALLOCCHECKALLOC found 0 allocation errors and 0 consistency errors in database CHECKDB found 0 allocation errors and 5492 consistency errors in database 'Orion'. Saturday, April 05, 2008 3:58 AM Reply | Quote All replies 0 Sign in to vote Hi, You need to refer the link http://support.microsoft.com/kb/828339, it's look's like hardware problem. 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 there some repair that I can run? ? Saturday, April 05, 2008 4:03 PM Reply | Quote 0 Sign in to vote You can try DBCC CHECKDB REPAIR_XXXX query to repair the db. Refer the link http://msdn2.microsoft.com/en-us/library/ms176064.aspx for more. Monday, April 07, 2008 3:55 AM Reply | Quote Moderator 0 Sign in to vote Have you tried repair option?? Is it worked?? Pls reply back!! 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 to understand
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums General SQL Server Forums Data Corruption Issues I/O error (bad page ID) detected during read at... Reply to Topic Printer Friendly Author Topic ProgressBoy Starting Member 14 Posts Posted-03/10/2009: 11:10:19 I have only seen this https://social.msdn.microsoft.com/Forums/sqlserver/en-US/88943bb5-1d86-444b-83ba-23952ac4e785/io-error-bad-page-id?forum=sqldatabaseengine error on SQL 2000 BOXES. Has anyone observed it on SQL 2005? Is it possible to get the same error in SQL 200%?I/O error (bad page ID) detected during read at offset ..... 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 And yes, you can see these on http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=121361 all versions.Paul S. Randal, Managing Director, SQLskills.com (www.SQLskills.com/blogs/paul)SQL Server MVP, Contributing Editor of TechNet MagazineAuthor of SQL 2005 DBCC CHECKDB/repair codeAuthor & Instructor of Microsoft Certified Master - Database course Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database Design and Application Architecture SQL Server 2012 Forums Transact-SQL (2012) SQL Server Administration (2012) SSIS and Import/Export (2012) Analysis Server and Reporting Services (2012) Replication (2012) Availability Groups and DR (2012) Other SQL Server 2012 Topics SQL Server 2008 Forums Transact-SQL (2008) SQL Server Administration (2008) SSIS and Import/Export (2008) High Availability (2008) Replication (2008) Analysis Server and Reporting Services (2008) Other SQL Server 2008 Topics SQL Server 2005 Forums Transact-SQL (2005) SQL Server Administration (2005) .NET Inside SQL Server (2005) SSIS and Import/Export (2005) Service Broker (2005) Replication (2005) High Availability (2005) Analysis Server and Reporting Services (2005) Express Edition and Compact Edition (2005) Other SQL Server Topics (2005) SQL Server 2000 Forums SQL Server Development (2000) SQL Server Administration (2000) Import/Export (DTS) and Replication (2000) Transact-SQL (2000) Analysis Services (2000) MSDE (2000) Development Tools ASP.NET Reporting Services Development Other Development Tools Site Related Forums Site Rela
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web http://database.ittoolbox.com/groups/technical-functional/sql-server-l/urgentio-error-bad-page-id-detected-during-read-at-offset-error-226394 Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Ramnath.Awate JoeTorre Andrew.S.Baker Locutus bracke Dennis Stevenson Craig Borysowich Richard DukeGanote mircea_luca iudithm Clinton Jones Nikki Klein AbhaiTripathi knowscognosdoi Iqbalyk bluesguyAZ59 blrvenkat COMPANIES Apperian ZOHO Corporation Vision Solutions Cisco View All Topics View All Members o error View All Companies Toolbox for IT Topics Database Groups Ask a New Question SQL Server The SQL Server group is a forum where peers share technical expertise, solve problems, and discuss issues related to Microsoft SQL Server. Home | Invite Peers | More Database Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this bad page id is your account,sign in here Email address Username Between 5 and 30 characters. 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 Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Urgent--I/O error (bad page ID) detected during read at offset error Unknown User asked Mar 11, 2003 | Replies (2) hi, i am getting this error when i am querying my database on SQL Server 2000 with SP3.why is this error coming?s Server: Msg 823, Level 24, State 2, Line 1 I/O error (bad page ID) detected during read at offset 0x000000a7e7c000 in file 'E:\DB\Support_Data.MDF'. Connection Broken Very urgent Thanks in advance Regards, Anees NOTE: The Name of the company has been changed from Wipro ePeripherals Ltd. to WeP Peripherals Ltd w.e.f August 2002. Join this group Popular White Paper On This Topic The Difference Between Microsoft Azure & Amazon AWS 2Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Unknown User replied Mar 11, 2003