Re: Remedy Disaster Recovery Solutions

[Luttmann, Michael W Ctr 21 SCS/SCBBN]

** 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 Senior Database Engineer [EMAIL PROTECTED]   From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Luttmann, Michael W Ctr 21 SCS/SCBBN Sent: Tuesday, September 26, 2006 10:09 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Disaster Recovery Solutions   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 Senior Database Engineer [EMAIL PROTECTED]   From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Marino, Melanie A Sent: Friday, September 22, 2006 9:47 AM To: arslist@ARSLIST.ORG Subject: Remedy Disaster Recovery Solutions   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 [EMAIL PROTECTED] ***************************************************************************** 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. ***************************************************************************** __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___