Revision history [back]

click to hide/show revision 1
initial version

Hi,

Normally, this incorrect next schedule time issue will be fixed once after editing the backup schedule. Since this issue is not resolved after editing the backup schedule, we provide you the manual steps to update Next Scheudle Time value in database.

Please follow the below instructions

1) Stop the VembuNetworkBackup Application running in the Client machine.

2) Now, open the command prompt (administrator command prompt) and go to the "<vembu_home>" location [By default, it will be 'C:\Program Files\Vembu\VembuNetworkBackup' ] and execute this command "lib\sqlite\sqlite3.exe data\sgclient.db " to open the database.

(here we assume, you have not changed the dbstorage location path and db files are present under <vembu_home>\data folder)

3) Execute the below query in database in order

i) To Get the Backup Config ID Select BACKUPCONFIGID from BACKUPCONFIG where BACKUPNAME=<backup_name>;

ii) To Update the current time as Next schedule time
update BACKUPSCHEDULES set NEXTSCHEDULETIME=(SELECT strftime('%s', 'now')) where BACKUPCONFIG_ID= <backup_config_id>;

iii) To confirm that current time is updated, please execute the below query select datetime(NEXTSCHEDULETIME, 'unixepoch', 'localtime') from BACKUPSCHEDULES WHERE BACKUPCONFIG_ID =<backup_config_id>;

4) Execute '.q' to close the database.

5). After that, start VembuNetworkBackup and resume/schedule the backups.

If the problem still exists, please send the result of last query (query mentioned in point iii), which will help us to give the suitable solution.

click to hide/show revision 2
No.2 Revision

Hi,

Normally, this incorrect next schedule time issue will be fixed once after editing the backup schedule. Since this issue is not resolved after editing the backup schedule, we provide you the manual steps to update Next Scheudle Time value in database.

Please follow the below instructions instructions

1) Stop the VembuNetworkBackup Application running in the Client machine.

2) Now, open the command prompt (administrator command prompt) and go to the "<vembu_home>" location [By default, it will be 'C:\Program Files\Vembu\VembuNetworkBackup' ] and execute this command "lib\sqlite\sqlite3.exe data\sgclient.db " to open the database.

(here we assume, you have not changed the dbstorage location path and db files are present under <vembu_home>\data folder)

3) Execute the below query in database in order

i) To Get the Backup Config ID Select BACKUPCONFIGID from BACKUPCONFIG where BACKUPNAME=<backup_name>;

ii) To Update the current time as Next schedule time
update BACKUPSCHEDULES set NEXTSCHEDULETIME=(SELECT strftime('%s', 'now')) where BACKUPCONFIG_ID= <backup_config_id>;

iii) To confirm that current time is updated, please execute the below query select datetime(NEXTSCHEDULETIME, 'unixepoch', 'localtime') from BACKUPSCHEDULES WHERE BACKUPCONFIG_ID =<backup_config_id>;

4) Execute '.q' to close the database.

5). After that, start VembuNetworkBackup and resume/schedule the backups.

If the problem still exists, please send the result of last query (query mentioned in point iii), which will help us to give the suitable solution.

Copyright © Vembu Technologies 2020. All Rights Reserved.