Timetrex not backing up
Timetrex not backing up
Just moved (with some help from Timetrex) everything to a new pc. Everything seems to be working except the database isn't being automatically backed up daily. It should, right? Maintenance jobs last run today at 10:07am. It does backup if I manually run the script. Thanks
Running on Windows 10
T/T version 9.0.4
installed with windows installer
Running on Windows 10
T/T version 9.0.4
installed with windows installer
Re: Timetrex not backing up
Please check your permissions, the maintenance jobs typically run as the "SYSTEM" user, so ensure that user can execute and write to the TimeTrex directory.
Re: Timetrex not backing up
"system" does have full permissions. One generic user I gave full permissions to.
Re: Timetrex not backing up
You would need to enable logging and check the logs for errors then.
Re: Timetrex not backing up
Do I have to wait until tonight to see if it fails to backup or is there a way to reproduce it and get the log info? I have enabled logging. Thanks
Re: Timetrex not backing up
You will need to wait until tonight.
Re: Timetrex not backing up
Which log would it be? There is a text log dated this morning, but it's rather lengthy.
Re: Timetrex not backing up
Thats likely it, you should be able to compress it and upload it here.
Re: Timetrex not backing up
According to the log file, the backup_database.bat file was run successfully, however it only took about 29 seconds to complete, so either your database is extremely small, or something else failed.
Re: Timetrex not backing up
Now I see timetrex_database_on. that was created the 15th in my t/t directory, should it not keep a week or so worth of backup files?
Re: Timetrex not backing up
Not sure what you mean by "timetrex_database_on"
Re: Timetrex not backing up
When Timetrex backs up the database, it creates a file in the Timetrex directory like "timtrex_database_on.16" if it was done on the 16th. It used to keep about a weeks' worth of backup files but it looks like now it just creates a file called "timetrex_database_on." when it automatically backs up at night.
Re: Timetrex not backing up
By default TimeTrex does not create files with that naming scheme (it creates files like: timetrex_database_20151201.sql), have you modified the backup_database.bat file yourself perhaps?
Re: Timetrex not backing up
You mentioned that if you run the backup_database.bat file manually, it creates a file, what is the exact file name? Can you also attach your backup_database.bat file here too please?
Re: Timetrex not backing up
timetrex_databse_on.16.sql
is the exact file name
it won't let me attach the .bat file for backup database
is the exact file name
it won't let me attach the .bat file for backup database
Re: Timetrex not backing up
You should be able to .ZIP it, or just copy and paste the contents here.
Re: Timetrex not backing up
here it is
- Attachments
-
- backup_database.zip
- (421 Bytes) Downloaded 252 times
Re: Timetrex not backing up
Unfortunately we are not able to replicate the issue on our end using Windows 10.
Re: Timetrex not backing up
Is my backup batch file as it should be?
Re: Timetrex not backing up
It appears to be, so my only guess is that there something specific to your server/operating system that is interfering with it.