You can restore data from a backup, though the procedure is a little long-winded.
1-restore the entire db (use a different db) as there is not a way to restore a single record out of a single table 2-locate the data you want to restore 3- manually move that data from the db you created from the restore to your production db. Axton Grams On 4/21/06, T. Dee <[EMAIL PROTECTED]> wrote: > I user asked me if we could restore an "attachment" from our backup. I've > never had anyone ask a question like this. Not sure if you can tell SQL > just to restore an attachment in a Form. > > > Joe DeSouza <[EMAIL PROTECTED]> said: > > > Not sure I understood your question.. do you loose your attachment in > question when you backup - which is the reason you want to do a restore of > that attachment after a backup? If so there is something abnormal. A backup > of a database should leave it intact. > > > > Joe > > > > Tyrone Dee <[EMAIL PROTECTED]> wrote: > > 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. > > > > --------------------------------- > > Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ > countries) for 2ยข/min or less. > > > > > _____________________________________________________________________________ > __ > > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > > > -- > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
