Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data Corrupt for BLOB objects Expand / Collapse
Author
Message
Posted Tuesday, September 24, 2013 10:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 21, 2014 2:43 PM
Points: 4, Visits: 62
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
Post #1497967
Posted Tuesday, September 24, 2013 12:26 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:13 PM
Points: 40,428, Visits: 36,879
How do you know they're corrupt?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1498007
Posted Tuesday, September 24, 2013 12:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 21, 2014 2:43 PM
Points: 4, Visits: 62
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
Post #1498011
Posted Tuesday, September 24, 2013 12:57 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:13 PM
Points: 40,428, Visits: 36,879
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 2008, MVP
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

Post #1498019
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse