Good point, Chris, and the DPBACKUP.EXE program was written just for that purpose. I don't remember exactly how it works, but it produces a backup without interference from ongoing transactions
On Wed, Jun 20, 2018 at 11:05 PM, Chris Pedersen <[email protected]> wrote: > There is a way to handle this. > > Backup programs have to handle this question all the time. How to backup > programs that are open and or sending receiving data. > > Good ones will buffer the io, then create a temporary copy, backup the > data and reestablish transaction to the original file. > > In Microsoft servers this is done via shadow copy feature, iirc. > > Having killed connections, and done this, I can tell you firmly this > approach works better. > ------------------------------ > *From:* Dataperf <[email protected]> on behalf of > [email protected] <[email protected]> > *Sent:* Wednesday, June 20, 2018 9:01:12 AM > > *To:* [email protected] > *Subject:* Re: [Dataperf] Forced log-out? > > I understand, Ed. > > I ran my backups automatically overnight and had them auto-zipped by PACL > (PowerArchiver Command Line), so they were quite light-weight and it didn't > matter if the batch-routine took some time: it worked while I slept... > > :) Geert > > > > On Tue, 19 Jun 2018 19:27:21 +0200, Ed Marfil, MAST UNITED < > [email protected]> wrote: > > Hi Geert, > > > > I’ve been running the “export all files to log” function which needs all > users to log-out before it will run. I decided on this option to keep the > file small and backing up only one file is very quick. > > > > Thanks, > > Ed. > > > > *From:* Dataperf [mailto:[email protected]] *On Behalf Of * > [email protected] > *Sent:* Tuesday, June 19, 2018 10:20 AM > *To:* [email protected] > *Subject:* Re: [Dataperf] Forced log-out? > > > > Hi all, > > > > I used to make fully automised daily backups of several DP POS-systems, > 'avoiding' the problem of logged-in users by making a *copy* of the > DataBase-files in a temporary folder first, and then backing up that > temporary folder and delete it afterwards. > > > > No need to log-off users, copying the files will work anyhow... > > > > :) Geert > > > > > > > > > > On Tue, 19 Jun 2018 18:59:20 +0200, Tim Rude <[email protected]> wrote: > > > > Another idea: > > On the machine that hosts the database files, use Computer Management to > close the open database files that errant users have left open. It won't > actually shut down DP on their computer, but when they come back and try to > use it they'll get an error message and have to exit. They can then re-run > DP and be back to normal. > > Tim Rude > > On 6/19/2018 10:49 AM, Ed Marfil, MAST UNITED wrote: > > Hello Peter, > > > > Thank you for the reply. Interesting that you use it for transport > management. I use it for the same; inventory and shipping management. > > > > Anyway, I was hoping I could disconnect the user solely from the DP > application or database but not from the server. > > > > Currently I have to remote log-in to the suspect station and properly log > it out. Unfortunately sometimes there are multiple suspects. > > > > Regards, > > > > Ed. > > > > PS: please know that I feel bad that NL is not in this cup. Just doesn’t > seem right without them and Italy. > > > > > > *From:* Dataperf [mailto:[email protected] > <[email protected]>] *On Behalf Of *Peter Boekestijn > *Sent:* Tuesday, June 19, 2018 6:29 AM > *To:* [email protected] > *Subject:* Re: [Dataperf] Forced log-out? > > > > Hi Ed, > > > > It happens to me quit often with approx 40 users working every day in our > transport management application. > > We work on a window server with terminal servers > > > > I work as follow: > > - Remove all *.tmp files (3 per user) > > - Some of them remain because of incorrect log-out > > - I get the names of those users from the files attributes > > - Next step is to log out those users from the server > > - Final step to remove the remaining *.tmp files > > > > Success > > > > Peter > > > > *Van:* Dataperf [mailto:[email protected] > <[email protected]>] *Namens *Ed Marfil, MAST UNITED > *Verzonden:* maandag 18 juni 2018 02:54 > *Aan:* [email protected] > *Onderwerp:* [Dataperf] Forced log-out? > > > > I back up my DP database regularly at off hours when it is supposed to be > inactive. However, there are times when it fails because a user forgot to > log-out of the database. > > I was wondering if there is a way to forcibly eject users from the > database. > > > > Thanks, > > Ed. > > > > > _______________________________________________ > > Dataperf mailing list > > [email protected] > > http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf > > > > [image: Image removed by sender.] > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> > > Garanti sans virus. www.avast.com > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> > > > > > > > -- > > Vriendelijke groeten, > Geert De Baets > mailto:[email protected] <[email protected]> > Web: http://www.debaets.be > > Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf > >
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
