You can use any DB backup mechanism you have access to. The AR System does all work in a transactionally consistent way. The DB is ALWAYS in a stable state between transactions (OK, if you are in the middle of restructuring, we do have to commit the metadata changes at a separate time of the actual DB restructure operations so you do want to avoid doing a backup while you are creating or modifying form definitions – but that is an obvious restriction).
As long as your on-line backup includes some form of transaction log capture for things "in flight", you should be good to go. Now, the other comments about making sure the restore process works and is timely and the like are definitely key points you need to have all figured out for this to really work. Doug From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, April 11, 2013 5:51 AM To: [email protected] Subject: R: Re: Taking a database backup with ARServer running. ** I know that I can take the DB backup even if the ARServer is running. This isn't my question (I'm also the DBA, I know that I can and I know how to do this [cid:~WRD000.jpg] ). The matter is if I can consider the ARServer "application consistent" because it's running. ----Messaggio originale---- Da: [email protected] Data: 11-apr-2013 14.47 A: <[email protected]> Ogg: Re: Taking a database backup with ARServer running. ** BTW its DB activity and not AR. Remedy does not have inbuilt mechanism to backup underlying DB. sent using Galaxy Nexus On Apr 11, 2013 6:12 PM, "Mayuresh Wagh" <[email protected]<mailto:[email protected]>> wrote: You should be able to do that. It would be transparent to AR. Online backup is possible. Check with DBA. sent using Galaxy Nexus On Apr 11, 2013 2:29 PM, "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> wrote: Hi All, Is there a remedy command that place the ARServer in a "consistent state" so i can freely backup the underlying database throught database native tools without the need of shutting down the ARServer? The goal is to take a database backup with application consistency having the ARServer up&running, minimizing the downtime. Is there any way? Thanks in advance, Ale. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> "Where the Answers Are, and have been for 20 years" _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
<<inline: ~WRD000.jpg>>
