Also other admin processes would continue to update the DB. Things like Escalations, Reconciliation Engine, Email Engine, Normalization, SLM. The only way to stop changes to the db is shut down the Remedy apps or put the db in a read-only mode but then the apps would most likely die.
Can you specify what you concern is? Our organization and many others restore ARSystem databases from backups all the time without issue. Yes there are probably some records out of sync due to timing of the backups but for our purposes it is good enough. It sounds like you might be doing more than just restoring production to dev where consistency is a bit more critical. Jason On Thu, Apr 11, 2013 at 8:02 AM, Longwing, Lj <[email protected]> wrote: > ** > Yes, putting in admin mode would stop all non admin level traffic...but > that kinda defeats the purpose of doing it 'online'.... > > > On Thu, Apr 11, 2013 at 8:55 AM, Drew Shuller <[email protected]>wrote: > >> ** >> Wouldn't putting the AR Server in Admin Only mode stop any transactions >> to the db? No one would be able to use the system, but it would take less >> time that a reboot. >> >> Drew >> JTF-Bravo >> Honduras >> >> >> On Thu, Apr 11, 2013 at 7:19 AM, Longwing, Lj <[email protected]> wrote: >> >>> ** >>> The only thing that should be 'in flight' during a backup would be data, >>> and that is going to happen any time an online backup is done, but the >>> application structure is 'consistent' by the fact that you aren't actively >>> making changes to it, so no concerns from that point. >>> >>> >>> On Thu, Apr 11, 2013 at 6:51 AM, [email protected] < >>> [email protected]> wrote: >>> >>>> ** >>>> >>>> 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 ). >>>> >>>> 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]> 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]" < >>>>> [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 >>>>>> "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_ >>>> >>> >>> _ARSlist: "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"
