Cyclic REdundancy error

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rahul Chatterjee (rahul_at_benesysinc.com)
Date: 08/04/04


Date: Wed, 4 Aug 2004 08:01:12 -0400

Hello All

I inserted data into my SQL Server table using BCP. THis went fine. When I
tried to index, I got the following error. Please advise as to possible
causes and solutions.

Server: Msg 823, Level 24, State 2, Line 1
I/O error 23(Data error (cyclic redundancy check).) detected during read at
offset 0x000000bb310000 in file 'H:\SqlDatabases\ECIHP4_Data.MDF'.

Thanks



Relevant Pages

  • RE: System.OutOfMemory Exception
    ... Consider creating a view in SQL Server that gets the data in the correct ... format and use a Process object to fire BCP to pull from this view. ... > to be "re-horizontalize" and served in a single flat file. ...
    (microsoft.public.dotnet.faqs)
  • RE: System.OutOfMemory Exception
    ... Consider creating a view in SQL Server that gets the data in the correct ... format and use a Process object to fire BCP to pull from this view. ... > to be "re-horizontalize" and served in a single flat file. ...
    (microsoft.public.dotnet.languages.vb)
  • RE: System.OutOfMemory Exception
    ... Consider creating a view in SQL Server that gets the data in the correct ... format and use a Process object to fire BCP to pull from this view. ... > to be "re-horizontalize" and served in a single flat file. ...
    (microsoft.public.dotnet.framework)
  • Re: BCP and table variables
    ... table variable but not if I use a global temp table. ... To be able to perform the copy-out operation, BCP needs to know the ... The way a client can determine what result set a query batch returns is to ... SQL Server does not perform statements like ...
    (microsoft.public.sqlserver.programming)
  • Re: On to Bulk Insert issues
    ... in what situations does the sql server 2000 return with such an error? ... there is an error with your delimiters, so that BCP gets out of sync. ... post the CREATE TABLE command for the table and the ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)