I got my Sql backups running at midnight then I have batch files doing
exports every 15 minutes via the Windows Scheduler of any form that would
update. In the batch file it saves the arx files to the local server and to
another server offsight.
The query of course would be anything >= $DATE$ since the database backup
has it to midnight. It just overwrites the old data. We only create about
150 HelpDesk tickets daily so it's not so tasking on my server. I'm on ARS
4.0.3 righ now though.
Then on the recovery end I got another batch file that will make sure the
Remedy services are off then load the most current backed up database to the
local server, then another batch to import the arx files. Then last to
enable the Remedy services and I'm up. The recovery process takes only 10
minutes. Since I also copy the backed up SQL database file to my offsite
server as well.
We're about to go to ARS 6.3 so I'm not sure yet if this same process will
work. The exports are actually the easy part since it's straight forward the
fun part is the recovery.
Steve
On 11/4/06, Mosco, John D. <[EMAIL PROTECTED]> wrote:
**
All,
I am trying to find the best way to make sure that I have a
good disaster revovery plan. I already set up SQL Backups full and diff
etc. From my class two weeks ago (admin 2) it seems the best way to be able
to bring your data back though is to do a data export and then import. Is
there anyway to automate this on a schedule or do I need to have my junior
admins just do this every day ?
Thanks,
John Mosco
W01/GS-11
IT Coordinator
Customer Support Manager
PNG JFHQ J6
Com: 717-861-8143
DSN: 312-491-8143
Fax: 717-861-8414
'We the people'
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
