Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Chirag23
Starting Member
13 Posts |
 Posted - 2011-10-17 : 09:20:55
|
| Hi,A users current BLOB file on the live server seems to have corrupted and I would like to restore this file from a previous backup which is on the test server. The live db is running SQL2000 and the test db is running SQL2005.I would like to export the existing BLOB file from the backup running a command like:Select TIMERS from USERST where USERID = 'CDP'The BLOB field is called TIMERS and the result shows something like this:0x04000000BEBA000423343234DDE ...etcWhat I'd like to do is just export this field and import it back into the live system, in the exact same location and replace whatever is there.Do I use something like Save results as... then take the CSV file and try this:UPDATE TIMERS="[copyfromcsv]" from USERST where USERID = 'CDP' I've yet to try this as I don't think this is the correct way of doing this and was hoping somebody could point me in the right direction.ThanksChirag |
|
|
|
|
|
Import/Export BLOB field