Why not set up a DTS package that would do this for you? SQL Server also has the ability to do scheduled tasks and you can set it to run the created DTS at any interval that you want..
HTH Clint ----- Original Message ----- From: "Paul Giesenhagen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 11, 2002 1:46 PM Subject: Backing up > Does anyone have any suggestions for me on this one: > > I have an MS SQL 2000 DB that has 6 tables. I also have exact duplicates > that I call my backup copies (or originals) of these 6 tables. > > I want to allow people to modify the first set of 6 tables, but every hour I > want to restore the 6 tables back to the orginal data (the data in the > backup copies). > > What would be the quickest, easiest way to make this happen . You may have > to be alittle detailed, I am slow?? > > I used to do this through CF by deleting all the data and then outputing the > orginals and inserting ...I would assume there is a better way. > > The only hitch is that I also have to move orignal files and images too .. > which means I would like to use the CF Schedular to do this. > > Anyhelp would be appreciated. > > Paul Giesenhagen > QuillDesign > http://www.quilldesign.com > SiteDirector - Commerce Builder v2.0 > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
