Timetrex not backing up

General support regarding TimeTrex, such as
configuring policies/taxes or processing payroll.
Post Reply
macbeth
Posts: 198
Joined: Wed Feb 25, 2009 1:06 pm

Timetrex not backing up

Post by macbeth »

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
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Timetrex not backing up

Post by shaunw »

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.
macbeth
Posts: 198
Joined: Wed Feb 25, 2009 1:06 pm

Re: Timetrex not backing up

Post by macbeth »

"system" does have full permissions. One generic user I gave full permissions to.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Timetrex not backing up

Post by shaunw »

You would need to enable logging and check the logs for errors then.
macbeth
Posts: 198
Joined: Wed Feb 25, 2009 1:06 pm

Re: Timetrex not backing up

Post by macbeth »

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
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Timetrex not backing up

Post by shaunw »

You will need to wait until tonight.
macbeth
Posts: 198
Joined: Wed Feb 25, 2009 1:06 pm

Re: Timetrex not backing up

Post by macbeth »

Which log would it be? There is a text log dated this morning, but it's rather lengthy.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Timetrex not backing up

Post by shaunw »

Thats likely it, you should be able to compress it and upload it here.
macbeth
Posts: 198
Joined: Wed Feb 25, 2009 1:06 pm

Re: Timetrex not backing up

Post by macbeth »

Here goes:
timetrexLogFile.zip
(491.81 KiB) Downloaded 291 times
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Timetrex not backing up

Post by shaunw »

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.
macbeth
Posts: 198
Joined: Wed Feb 25, 2009 1:06 pm

Re: Timetrex not backing up

Post by macbeth »

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?
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Timetrex not backing up

Post by shaunw »

Not sure what you mean by "timetrex_database_on"
macbeth
Posts: 198
Joined: Wed Feb 25, 2009 1:06 pm

Re: Timetrex not backing up

Post by macbeth »

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.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Timetrex not backing up

Post by shaunw »

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?
macbeth
Posts: 198
Joined: Wed Feb 25, 2009 1:06 pm

Re: Timetrex not backing up

Post by macbeth »

Heck no!
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Timetrex not backing up

Post by shaunw »

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?
macbeth
Posts: 198
Joined: Wed Feb 25, 2009 1:06 pm

Re: Timetrex not backing up

Post by macbeth »

timetrex_databse_on.16.sql

is the exact file name

it won't let me attach the .bat file for backup database
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Timetrex not backing up

Post by shaunw »

You should be able to .ZIP it, or just copy and paste the contents here.
macbeth
Posts: 198
Joined: Wed Feb 25, 2009 1:06 pm

Re: Timetrex not backing up

Post by macbeth »

here it is
Attachments
backup_database.zip
(421 Bytes) Downloaded 250 times
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Timetrex not backing up

Post by shaunw »

Unfortunately we are not able to replicate the issue on our end using Windows 10.
macbeth
Posts: 198
Joined: Wed Feb 25, 2009 1:06 pm

Re: Timetrex not backing up

Post by macbeth »

Is my backup batch file as it should be?
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Timetrex not backing up

Post by shaunw »

It appears to be, so my only guess is that there something specific to your server/operating system that is interfering with it.
Post Reply