If you are using Microsoft SQL, you can do log shipping fairly easily and that will keep the two databases nearly identical. You can most assuredly do something similar in Oracle -- I've just never done it.
I have a document that describes how to enable log shipping in Microsoft SQL 2000 (should work in later versions, too). I can forward you a copy if you're interested. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Tuesday, July 29, 2008 10:51 AM To: arslist@ARSLIST.ORG Subject: Syncing two forms in two different servers for failover Hi: I have one remedy server in production and another as a cold stanby in a different location. I have the same form in both servers. Is there anyway to keep the data on this form in the two server identical including the REQUEST_ID for the form? Maybe synced up to the last hour ? Can I just copy the data in T, H and B tables every hour from the production to the standby server maybe once every hour. Thanks Ravi ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"