Operating System Error 23 Data Error Cyclic Redundancy Check
Contents |
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » Data Corruption sql server error 23 data error cyclic redundancy check » Data error (cyclic redundancy check) failed.... Data error (cyclic redundancy check) failed. the operating system returned error 23(data error (cyclic redundancy check).) to sql server with 24 consistency errors Rate Topic Display Mode Topic Options Author Message amjadparachaamjadparacha Posted Thursday, June 19, 2008 3:17 AM unable to read and latch page with latch type sh. 23(data error (cyclic redundancy check).) failed. Forum Newbie Group: General Forum Members Last Login: Friday, July 10, 2009 6:21 AM Points: 3, Visits: 6 I am having these errors while I run DBCC CHECKDB ( myDB )Msg 8966, Level
Data Error Cyclic Redundancy Check Sql Server 2008
16, State 2, Line 1Unable to read and latch page (1:2542368) with latch type SH. 23(Data error (cyclic redundancy check).) failed. Msg 8964, Level 16, State 1, Line 1Table error: Object ID 2020202247, index ID 1, partition ID 72057594145669120, alloc unit ID 72057594087800832 (type LOB data). The off-row data node at page (1:2444050), slot 0, text ID 901891555328 is not referenced.I have already executed dbcc backup failed 23(data error (cyclic redundancy check) dbreindex(myTable) successfully, but I'm still having errors.please comment. Post #519683 tosscrosby tosscrosby Posted Thursday, June 19, 2008 7:18 AM SSCrazy Group: General Forum Members Last Login: Tuesday, April 19, 2011 7:31 AM Points: 2,666, Visits: 5,316 Check these out. Paul is the best when discussing corruption. It's definitely not the best scenario for you but may at least get you started.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=104090http://www.eggheadcafe.com/forumarchives/SQLServerserver/Jul2005/post23536458.asp -- You can't be late until you show up. Post #519839 GilaMonsterGilaMonster Posted Thursday, June 19, 2008 7:34 AM SSC-Forever Group: General Forum Members Last Login: Yesterday @ 6:16 PM Points: 45,436, Visits: 43,787 Do you have a backup of that database? Gail ShawMicrosoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enterWe stand on the bridge and no one may pass Post #519855 amjadparachaamjadparacha Posted Thursday, June 19, 2008 8:40 AM Forum Newbie Group: General Forum Members Last Login: Friday, July 10, 2009 6:21 AM Points: 3, Visits: 6 unfortunately i don't have backup. Post #519916 MannySinghMannySingh Posted Thursday, June 19, 2008 8:53 AM SSChasing Mays Group: General Forum Members Last Login: Friday
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings read on failed 23 data error cyclic redundancy check and policies of this site About Us Learn more about Stack Overflow
The Operating System Returned Error 23 To Sql Server During A Read At Offset
the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users
System.data.sqlclient.sqlerror Read On Failed 23
Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in http://www.sqlservercentral.com/Forums/Topic519683-266-1.aspx the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top SQL Server Rebuild/Reorganize Fragmented Indexes causes CRC error or consistency errors up vote 3 down vote favorite In our test lab I've been experimenting with different jobs http://dba.stackexchange.com/questions/18535/sql-server-rebuild-reorganize-fragmented-indexes-causes-crc-error-or-consistency to keep our critical indexes from becoming too fragmented. I'm currently using the approach described here: sys.dm_db_index_physical_stats (under the Examples -> D section: Using sys.dm_db_index_physical_stats in a script to rebuild or reorganize indexes). Basically every hour I query the dm_db_index_physical_stats dynamic management view and if an index is between 5% and 30% fragmented I reorganize it, if it's greater than 30% fragmented I rebuild it. It seems to work fine during most of our testing, however, twice I've run into a problem where the scheduled job fails with an error: The operating system returned error 23(Data error (cyclic redundancy check).) to SQL Server during a read at offset 0x00000eae3b2000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\database.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. [SQLSTATE HY000] (Error 823) When I run DBCC CHECK
which need urgent investigation. The error will also almost certainly arise if you try to copy the file using Windows Explorer. This article has more details.Note that the error http://support.2brightsparks.com/knowledgebase/articles/215714-23-data-error-cyclic-redundancy-check may be on either source/left or destination/right, unless either of these is a non-Windows resource such as FTP, in which case it will be on the 'other side', as it is not possible for http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=83310 a non-Windows resource to return a Windows error message - ipso facto, the error is coming from the side where Windows is 'involved'.It isquite possible you also see the Windows error 1392: "The file data error or directory is corrupted and unreadable" in such circumstances. The reasons will be much the same - disk or folder\file corruption. This article was helpful (thinking…) · Flag this article as inaccurate…Flag this article as inaccurate… · Admin → New and returning users may sign in Sign in prestine Your name Your email address Check! invalid email (thinking…) Reset or sign in with UserVoice password Forgot password? Create cyclic redundancy check a password I agree to the Terms of Service Signed in as (Sign out) Close Close Sign in Sign in Sign up Cancel Technical Articles Information to include for technical support Bug Reporting Creating a debug information file SyncBack Touch Guide Why SyncBack Touch Does Not Work With iOS The Syncback Management System Guide Safe Computing Your Software Broke My Hardware Known bugs and problems with SyncBack Transferring profiles from one computer to another The Format of the Text Log File Running SyncBack from an external storage device Receiving the log email on profile run Access Denied Error Message Access Denied for folder System Volume The Differences Between File Systems Automatic backup and sync when files change Windows Task Scheduler Fails Assigning a drive letter to external USB The Windows Task Scheduler How to see the list of scheduled jobs Starting and Stopping the Windows Scheduler How to set up a different schedule at the weekends to that of a weekday Auto-shut down after running a schedule Variables Cannot see hidden folders How to set the error level for a batch file Scheduling Other Jobs with SyncBack Creating a network share to backup or synchronize HTML Help File Problems How to troubleshoot hibe
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 New to SQL Server Programming Suspect database Reply to Topic Printer Friendly Author Topic albertkohl Aged Yak Warrior USA 740 Posts Posted-05/09/2007: 11:01:26 Okay, so i have a tabase named "TEST" that i set up, everything in it is for a website i've been designing slowly for the last month, i come in today, and notice the database is marked suspect. look at the log and i see all of this:Recovery of database 'Test' (7) is 20% complete (approximately 305 more seconds) (Phase 2 of 3).ForwardLogBlockReadAheadAsync: Operating system error 23(Data error (cyclic redundancy check).) encountered.Operating system error 23(Data error (cyclic redundancy check).) on device 'C:\Program Files\Microsoft SQL Server\MSSQL\data\Test_Log.LDF' during ForwardLogBlockReadAheadAsync.Error: 3313, Severity: 21, State: 2Error while redoing logged operation in database 'Test'. Error at log record ID (8440:42526:1)..Error: 3414, Severity: 21, State: 1Database 'Test' (database ID 7) could not recover. Contact Technical Support..Now, honestly, i could care less about the data, the thing the matters most to me, is the couple of stored procedures i've developed.what can i do? harsh_athalye Flowing Fount of Yak Knowledge India 5581 Posts Posted-05/09/2007: 11:04:21 Don't you have backup of the database? Don't you store your stored procs as a scripts in version control system?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" nr SQLTeam MVY United Kingdom 12543 Posts Posted-05/09/2007: 11:04:57 Set it to emerggency mode.in v2005 that's an alter databasein v2000 seehttp://www.nigelrivett.net/SQLAdmin/RecoverCorruptDatabase.htmlThen you should be able to use sp_helptext to get the SP's - if not look in syscomments.and what harsh_athalye said.==========================================Cursors are useful if you