Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
Job running every 7 minutes instead of once every 24 hours Options · View
joeri10
#1 Posted : Friday, July 29, 2011 7:06:16 AM Quote
Rank: Newbie

Groups: Registered

Joined: 7/29/2011
Posts: 3
Location: Belgium
just purchased a copy of the Lite version

On our win 2008 server I created a new job with a full backup every 24 hours and incremental every 2 hours to my ftp-server( local NAS)
It rungs smoothly.

It is set to start tomorrow morning at 06.00H. But it is already doing full backups every 7 minutes!!! I get an e-mail confirmation of a successful job (run as a service).
How is this happening?

Jobinfo below....
Quote:
<?xml version="1.0"?>
<JobInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" JobID="112a9fb5-cf22-4547-84ff-abde907a2186" AllNonSystemDb="false" TempFolder="" LogFolder="" DbTimeout="10000" UseWebLog="true">
<SqlServer Server=".\SQLSERVER2008" User="xxxxxxx" Password="xxxxxxxxxxxxx" IntegratedSecurity="false" />
<Databases>
<Database>Delphicare</Database>
<Database>Greenock</Database>
<Database>GreenockINN</Database>
<Database>GreenockSvcLogging</Database>
</Databases>
<Folders />
<Local Enable="false" Folder="" KeepMonths="6" KeepDays="0" />
<Ftp Enable="true" Uri="ftp://10.10.0.55:21/NetBackup" User="backup" Password="xxxxxxxxxxx" KeepMonths="6" KeepDays="0" DataConnection="Passive" Protocol="FTP" TraceLog="false" />
<Email SendOnDiffSuccess="false" SendOnTranSuccess="false" ZeroConfig="true" Enable="true">
<SuccessMail To="xxxxxxxxxxxxx@telenet.be" From="xxxxxxxxxx@telenet.be" User="" Password="" SmtpServer="" Port="25" SSL="false" />
<FailureMail To="xxxxxxxxxxxxx@telenet.be" From="xxxxxxxxxxxk@telenet.be" User="" Password="" SmtpServer="" Port="25" SSL="false" />
</Email>
<Run Enable="true" DateTime="2011-07-29T06:00:52" UseService="true" SchedulerAccount="" FullBackupEnabled="true" FullBackupInterval="1440" DiffBackupEnabled="true" DiffBackupInterval="120" LogBackupEnabled="false" LogBackupInterval="0" AutoDeleteOldDiffLog="false" />
<Zip Password="" CompressLevel="Normal" EncryptMethod="Compatible" EncryptStrength="256" ZipToTemp="false" />
<SqlScripting ScriptAlways="false" MaxScriptSize="10000" />
<ScriptBefore />
<ScriptAfter />
<OutputFormat>DateTime</OutputFormat>
</JobInfo>
mikeshilov
#2 Posted : Friday, July 29, 2011 7:13:32 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
thank you for the feedback, what's the program version?

note that as a customer you may use our support form (http://sqlbackupandftp.com/contact/) for priority support
joeri10
#3 Posted : Friday, July 29, 2011 10:04:23 AM Quote
Rank: Newbie

Groups: Registered

Joined: 7/29/2011
Posts: 3
Location: Belgium
My version is 6.0.11.30933.
The Full backup keeps on running 63 times and counting :-)
Should I kill the service?
mikeshilov
#4 Posted : Friday, July 29, 2011 10:11:04 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
No need to kill the service, you may just open the program, press Jobs button and delete the job.

Could you please send us Windows Log records related to SqlBackupAndFtp.
joeri10
#5 Posted : Friday, July 29, 2011 11:49:07 AM Quote
Rank: Newbie

Groups: Registered

Joined: 7/29/2011
Posts: 3
Location: Belgium
Send you the log files in a PM
mikeshilov
#6 Posted : Tuesday, August 02, 2011 4:43:17 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
This issue is fixed in version 6.0.12
Guest
#7 Posted : Thursday, August 04, 2011 5:12:02 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 732
I have test the Tool in our Business in the last days and i have the same failure with scheduled jobs.
Thank you for the fast Fix and now it works good. :-)

Currently i use the Free Version V 6.1.0.27516 for the tests
I have a scheduled Job every 4h and auto delete the old backups after 1 day. I think 1 day = 24h
I have start the Job on 19:00 Hour and in the morning i have only the backups from 03:00 and 07:00 on the HDD but the email says all Backups including the 19:00 and 23:00 is done without failure.
Use you only the Date stamp for the auto delete Function ? I think it was better to use date and time stamp.
mikeshilov
#8 Posted : Thursday, August 04, 2011 9:59:58 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
We use date and time. Look at the program log, it should write there when it removes the old backups
Guest
#9 Posted : Thursday, August 04, 2011 10:44:59 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 732
The log say that all Backup files from 03.08.2011 was removed on the first backup on 04.08.2011
Not after 24h, it removes with the new day date

Code:

04.08.2011 03:00:08    Creating backup of business to C:\WINDOWS\TEMP
04.08.2011 03:01:21    Backup of business completed
04.08.2011 03:01:21    Zipping C:\WINDOWS\TEMP\business201108040300.bak to C:\WINDOWS\TEMP\business201108040300.zip
04.08.2011 03:06:47    Zip completed (compressed size: 894.409 KB)
04.08.2011 03:06:47    Copying C:\WINDOWS\TEMP\business201108040300.zip to D:\Backup\business201108040300.zip
04.08.2011 03:07:45    Removing the backup: C:\WINDOWS\TEMP\business201108040300.bak
04.08.2011 03:07:45    Removing business201108040300.zip from C:\WINDOWS\TEMP
    
04.08.2011 03:07:45    Starting folder backup
04.08.2011 03:07:45    Zipping C:\Programme\StarMoney Business 5.0\profil\restore\SMB50 to C:\WINDOWS\TEMP\SMB50201108040307.zip
04.08.2011 03:07:50    Zip completed (compressed size: 13.505 KB)
04.08.2011 03:07:50    Copying C:\WINDOWS\TEMP\SMB50201108040307.zip to D:\Backup\SMB50201108040307.zip
04.08.2011 03:07:50    Removing SMB50201108040307.zip from C:\WINDOWS\TEMP
04.08.2011 03:07:50    Cleaning D:\Backup
04.08.2011 03:07:50    Removing business201108031530.zip from D:\Backup
04.08.2011 03:07:50    Removing business201108031630.zip from D:\Backup
04.08.2011 03:07:50    Removing business201108031900.zip from D:\Backup
04.08.2011 03:07:50    Removing business201108032300.zip from D:\Backup
04.08.2011 03:07:50    Removing SMB50201108031539.zip from D:\Backup
04.08.2011 03:07:50    Removing SMB50201108031638.zip from D:\Backup
04.08.2011 03:07:50    Removing SMB50201108031907.zip from D:\Backup
04.08.2011 03:07:50    Removing SMB50201108032307.zip from D:\Backup
04.08.2011 03:07:50    Sending a report (Success) to user@mail.de (Automatic)
04.08.2011 03:07:55    The report has been successfully sent
04.08.2011 03:07:55    Job finished


What is wrong?
mikeshilov
#10 Posted : Thursday, August 04, 2011 3:02:08 PM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
Yes, according to the log it just deletes yesterday's backups. Thank you for reporting! Will be fixed.
Guest
#11 Posted : Thursday, August 04, 2011 3:31:32 PM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 732
Thank you for the fast and good support. This is not standart for a free version.
I think when this solution is fixed we buy a Professional or liftime Version and then we have a very good solution for our business. Great Tool!
mikeshilov
#12 Posted : Friday, August 05, 2011 2:20:46 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
Please download and try a new version (6.1.2).
Gerd
#13 Posted : Friday, August 05, 2011 2:44:29 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 732
ok, i have installed the new Version and i try it.
Must i restart the Jobs or work the new version after installation without doing anything?
You become response from me in the next days
mikeshilov
#14 Posted : Friday, August 05, 2011 5:17:11 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
it's not necessary to restart the jobs
Gerd
#15 Posted : Monday, August 08, 2011 1:52:43 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 732
the new version works perfect!
1 day have now 24h
thank you!
mikeshilov
#16 Posted : Monday, August 08, 2011 1:56:15 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
you are welcome and thank you for reporting this
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.