Operating System Error 23data 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. with
The Operating System Returned Error 23(data Error (cyclic Redundancy Check).) To Sql Server
24 consistency errors Rate Topic Display Mode Topic Options Author Message amjadparachaamjadparacha Posted Thursday, June 19, 2008 3:17 AM Forum unable to read and latch page with latch type sh. 23(data error (cyclic redundancy check).) failed. 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 dbreindex(myTable)
Backup Failed 23(data Error (cyclic Redundancy Check)
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, August 15
SQL) » SqlBackupAndFTP General » https://sqlbackupandftp.com/forum/yaf_postst590_failed-23Data-error-cyclic-redundancy-check.aspx failed: 23(Data error (cyclic redundancy check).) failed: 23(Data error (cyclic redundancy check).) Options · View Previous Topic · Next Topic phraktal #1 Posted : Saturday, August 18, 2012 1:07:11 PM Rank: NewbieGroups: Registered Joined: 8/18/2012Posts: 1 SQL Server 2008 Express R2I've been getting cyclic redundancy these errors while backing up. This config used to work for few months now, and suddenly recently started to generate these errors:>>> run 8/18/2012 1:57:45 PM by AdministratorSQLBackupandFTP 7.1.5.29511 Free (started manually) at WIN-7FLUNI7034S (Microsoft Windows NT 6.1.7601 Service Pack 1) (.NET: 2.0.50727.5420, 3.0.30729.5420, cyclic redundancy check 3.5.30729.5420)SUMMARY:Database somedb: - FailedDETAILED LOG:8/18/2012 1:57:29 PM Creating backup of somedb to C:\Windows\TEMP (full)8/18/2012 1:57:44 PM ERROR: Read on "c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\somedb.MDF" failed: 23(Data error (cyclic redundancy check).)BACKUP DATABASE is terminating abnormally.8/18/2012 1:57:44 PM ERROR: Job finished (With Errors)>>> run 8/18/2012 8:00:41 AM by SYSTEMSQLBackupandFTP 7.1.5.29511 Free (run as service) at WIN-7FLUNI7034S (Microsoft Windows NT 6.1.7601 Service Pack 1) (.NET: 2.0.50727.5420, 3.0.30729.5420, 3.5.30729.5420)SUMMARY:Database somedb: - FailedDETAILED LOG:8/18/2012 8:00:28 AM Creating backup of somedb to C:\Windows\TEMP (full)8/18/2012 8:00:40 AM ERROR: Read on "c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\somedb.MDF" failed: 23(Data error (cyclic redundancy check).)BACKUP DATABASE is terminating abnormally.8/18/2012 8:00:40 AM ERROR: Job finished (With Errors)>>> run 8/18/2012 12:00:33 AM by SYSTEMSQLBackupandFTP 7.1.5.29511 Free (run as service) at WIN-7FLUNI7034S (Microsoft Windows NT 6.1.7601 Service Pack 1) (.NET: 2.0.50727.5420, 3.0.30729.5420, 3.5.30729.5420)SUMMARY:Database somedb: