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]] On Behalf Of Peter Boekestijn Sent: Tuesday, June 19, 2018 6:29 AM To: [email protected]<mailto:[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]] Namens Ed Marfil, MAST UNITED Verzonden: maandag 18 juni 2018 02:54 Aan: [email protected]<mailto:[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]<mailto:[email protected]> http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf [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] 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
