Tyrone, As far as I am aware, the only way to extract attachments stored within a Remedy attachment field is through the API, User Tool or Mid-Tier... because of the proprietary way ARS compresses the data. If anyone else knows a method to extract an attachment directly from SQL tables, please share.
While we are on the subject, another option that has been discussed previously is saving the attachments outside of Remedy in folders on a server. Then, you would be able to restore individual files from your regular server backup jobs. If you decide to store attachments outside of Remedy forms, you might also be able to store them in a SQL table. Then, after restoring the SQL backups to a separate database, you could extract the attachment from the table. HTH. Stephen -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tyrone Dee Sent: Friday, April 21, 2006 9:08 AM To: [email protected] Subject: Question: SQL Restore I'm not sure if this is possible, but when we do a complete SQL backup every night can a restore of one attachment be done? SQL 2000 Thanks. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
