Data Corrupt for BLOB objects

Question

Data Corrupt for BLOB objects

jshmccal

Old Hand

Points: 328
More actions
September 24, 2013 at 10:24 am

#298278

We recently copied table structure and data containing BLOB objects to new database. All of the objects are corrupt in the new database now. How do I handle table refreshes or coping BLOB objects. Thanks for your help!! Jack:ermm:

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

How do you know they're corrupt?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

jshmccal Old Hand Points: 328 More actions · Answer 2

We are using coldfusion code to display the objects. PDF in this case. The code works in our Dev. Table created in test and coldfusion code deployed to test. Adobe opens says object is corrupt.

Thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

That's not database corruption (you'd get errors from SQL if it was, not adobe)

Without seeing how you're importing, make sure that nothing's getting truncated anywhere or converted to incorrect data types.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass