**
I’ve received several requests for this already…
and I will forward my procedures to all who asked. That said, our
solution is very similar to some of the previous posts: -
Use log shipping if possible. (We
don’t have SQL Enterprise, but I have configured off-site backups using
the SQL Agent and a custom Backup device.) -
Use (or get) Hot Backup licenses
from BMC. It just requires that you fill out an agreement form that you
will not abuse them. -
Know how to set up MS SQL Maintenance
Plans to do full backups and transaction logs (ours run every 30 min.) -
Know how to use MS SQL restore
processes, including the restoring of transaction logs. -
Database replication is the
fastest way to maintain a backup, but may prevent you from using the target
server for development. (We have limited hardware resources.) -
Coordinate with your Sys Admins to
have tape backups made from your database backup directory. That way, you’ll
be able to go back as far as you want to. The only thing about my written procedure is that it’s…
written. The Air Force requires contractors like me to have such procedures
updated and posted. Mike Luttmann
From: Action Request
System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of I just went through this process on Friday, when the RAID
controller on my production server failed catastrophically (is there any other
way?). If you need a comprehensive document, let me know and I’ll send
you what I have (Bonus: it was just tested and updated with lessons
learned!) Possible drawback: we are on Windows 2003 Server and MS SQL
Database. Cheers, Mike Luttmann
From: Action Request System
discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Marino, Melanie A Can anyone share with me what their company is using for
Remedy Disaster Recovery? We are looking to replicate our Remedy
production environment to another site in real-time and switch back and forth
between the servers as needed. We are trying to determine the best
solution. We are running on a Solaris machine and an Oracle DB. Your help would be greatly appreciated. Thanks, Melanie Marino Project Manager KPMG LLP *****************************************************************************
The information in this email is
confidential and may be legally privileged. It is intended solely for the
addressee. Access to this email by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful. When
addressed to our clients any opinions or advice contained in this email are
subject to the terms and conditions expressed in the governing KPMG client
engagement letter. *****************************************************************************
|
Re: Remedy Disaster Recovery Solutions
Luttmann, Michael W Ctr 21 SCS/SCBBN Tue, 26 Sep 2006 10:29:11 -0700
- Re: Remedy Disaster Recovery Solution... Luttmann, Michael W Ctr 21 SCS/SCBBN
- Re: Remedy Disaster Recovery Sol... Aaron Keller
- Re: Remedy Disaster Recovery Sol... John Sundberg