We have a large table that stores file data in a column with an Image data type. One of the records appears to have corrupt data. When trying to select the record with the file data, I get the following error:
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
If I leave out the Image column when I select, it works.
The record is old and no longer needed, so I tried to delete it and got this error:
SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xf261f234; actual: 0xd8f1ee87). It occurred during a read of page (1:1687725) in database ID 5 at offset 0x0000033815a000 in file 'D:\Data\xxxx.mdf'. Additional messages in the SQL Server error log or operating system error log may provide more detail. This is a severe 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.
I am also unable to set the Image column to null. Is there some way I can remove this record? It is an old record, so any database backups we still have would have the same issue.