Any windows command line guru's on here? Need help.
Discussion
I need some help with a script/batch file. On a customers site, we do a daily backup of a database, but this has to be done late evening so that everybody's logged out and and the files aren't locked. Before I got here they were simply using teamviewer to log in and copy the files over manually every night. I wrote a batch file to be run via task scheduler to add them into a zip archive and then upload it to an FTP site on our server.
Which has worked but also come into some issues, people are leaving themselves logged into the application and keeping the lock on the files, which then causes an error with win rar as it brings up a message to say it can't access the files due to being in use. Which put's a big spanner in the works as until the message box is closed it does not carry on with the script and also keeps task scheduler stuck on this one task meaning the other tasks don't run either.
What I want to know is, is there a command line argument to close all open files in one shared folder. I have done a search and the only commands I have found either require you to know the exact ID of the open file which alters all the time, or just to simply close the entire lot which also wouldn't be any good as there other processes/users on at that time using those files.
Which has worked but also come into some issues, people are leaving themselves logged into the application and keeping the lock on the files, which then causes an error with win rar as it brings up a message to say it can't access the files due to being in use. Which put's a big spanner in the works as until the message box is closed it does not carry on with the script and also keeps task scheduler stuck on this one task meaning the other tasks don't run either.
What I want to know is, is there a command line argument to close all open files in one shared folder. I have done a search and the only commands I have found either require you to know the exact ID of the open file which alters all the time, or just to simply close the entire lot which also wouldn't be any good as there other processes/users on at that time using those files.
Maybe a bit of powershell? https://gallery.technet.microsoft.com/scriptcenter...
LeeThr said:
It's a product called Ffenics, derived from Data Ease.
I've been told that the simplest way of backing it up is to simply just copy the entire folder the application is stored in. It's just the file locking that causes an issue.
New one on me had a quick look round their website and won't be using it any time soon.I've been told that the simplest way of backing it up is to simply just copy the entire folder the application is stored in. It's just the file locking that causes an issue.
If Ffenics say that's the way to back up then you can't do much other than trust them. I'd just make sure you regularly restore the backup to a staging server to make sure it actually works.
Some companies just do odd things, I once worked for an outfit where the developers hated Microsoft so much that they spent most of their day complaining about MS (despite all the customers using it) and then spent 3 years writing a really really really really s
t alternative to MFC that was useless, rather than just getting on with what they were supposed to be doing and making money. Ended up with a muppet application that looked like a kids activity centre.
Couldn't get out fast enough.
But yes, I would agree, why not just use a proper database that can be backed up whilst running, seems like the kind of requirement that would be a show stopped to me.
t alternative to MFC that was useless, rather than just getting on with what they were supposed to be doing and making money. Ended up with a muppet application that looked like a kids activity centre.Couldn't get out fast enough.
But yes, I would agree, why not just use a proper database that can be backed up whilst running, seems like the kind of requirement that would be a show stopped to me.
jjlynn27 said:
WinRAR is doing you a favour. Just copying (presumably database) files is surefire way of not having consistent backup. Did you ever try to restore from all those files that you are copying across?
Yes we have, and there's never been a problem with the replicated data. Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff