We have used a Perl script that uses the runmacro command line utility (from our Solaris ARS server) to export data hourly and daily for data backups from the application level for a few years now. The down side to this approach is that we are doing a separate login per ARS Form to get the data, but we have yet to think we need to do any of this work in parallel too. (So the process is serially backing up each form as it loops through the Forms list.) So we know we can cut these times in about half by just backing up two forms at a time too. Oh and the Perl script has enough logic added to it to have excluded and mandatory include lists so that we can totally control what forms are backed up and when. The script also takes a command line parameter for the query to use to do the backup task for that set of forms on that specific run of the script. Anyway... We do occasionally also get "timeout" errors in these processes, but since these are our secondary backups (first backups are RDBMS backups, with transaction logs) we do not worry about those to much.
FWIW: Our incremental backups, that gets all data changed that day, currently can backup about 10788 data rows in 166 ARS Forms in about 10 minutes. Our nightly full backups backup 3294763 rows in about 5.5 hours for the same 166 ARS Forms. We also do a separate once a week full backup for our single largest form. That currently backs up 2134886 rows and takes about 4.5 hours for the single form. HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Tue, May 20, 2008 at 7:19 AM, Ravi <[EMAIL PROTECTED]> wrote: > Hi: I have a form which stores all the emails that are sent out by AR Email > engine. I want to back up data older than 3 months on a tape drive for upto > 3 years. Whatz the best way to back up data so it's available for retrieval > in case I have to review the old emails? I didn't think I could just backup > the data in that table from via sqlplus? I want to be able to automate the > process so end of every month the data for current month - 4 months is > backed up. > > Thanks > Ravi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
