|
|
|
Rank: Newbie
Groups: Registered
Joined: 7/14/2011
Posts: 2
|
We are having a performance issue on a new installation where we are testing your software for purchase.
Problem: backup finishes at 1:07am, but SQLBackupAndFTP.exe runs for an additional 8 to 24 hrs consuming a significant amount of CPU Cycles
Version 5.7.7.24417 trial/free version
Dual Quad core Xeon CPUs
16GB RAM
Server 2008R2 54 bit
SQL 2008R2 express
SQLBackupAndFTP set to run at 1AM on 1 database approximately 2GB in size
File is then zipped to local cache then coped to mapped network drive.
zipped File is finished copying by 1:10AM and is 234MB in size(10 minutes from start of scheduled job)
Latest log file
>>> run 7/14/2011 1:07:07 AM by administrator
SqlBackupAndFtp 5.7.7.24417 (Free)
SUMMARY:
Database C:\OPS\DATA\SMD DATA.MDF: Backup - Success
DETAILED LOG:
7/14/2011 1:00:02 AM Creating backup of C:\OPS\DATA\SMD DATA.MDF to C:\Windows\TEMP
7/14/2011 1:03:30 AM Backup of C:\OPS\DATA\SMD DATA.MDF completed
7/14/2011 1:03:30 AM Zipping C:\Windows\TEMP\C__OPS_DATA_SMD_DATA_MDF201107140100.bak to T:\SQL 2008 Backups\C__OPS_DATA_SMD_DATA_MDF201107140100.zip
7/14/2011 1:07:07 AM Zip completed (compressed size: 234,924 KB)
7/14/2011 1:07:07 AM Removing the backup: C:\Windows\TEMP\C__OPS_DATA_SMD_DATA_MDF201107140100.bak
7/14/2011 1:07:07 AM Cleaning T:\SQL 2008 Backups
7/14/2011 1:07:07 AM Job finished
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
Please try our new version (6.0)
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 7/14/2011
Posts: 2
|
Thank you for the suggestion.
upgraded to version 6
same symptoms as before. Job finished at 1:07am, EXE ran until after 8AM.
Any more Ideas?
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
After backup is done SBF should close and consume no resources at all. If you could wait a week, we can email you a special test version that would test/eliminate the problem.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
jrvandy, Can you give your email for us to contact you regarding testing? You may write us via http://sqlbackupandftp.com/contact/ and we'll contact you. BR, Mike
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 9/2/2011
Posts: 1
|
I am having the exact same issue. A full backup of 3 db's (1 large, 2 very small) started at 9:45PM last night and completed successfully at 11:18PM. This morning at 9:30AM I checked CPU utilization and SQLBackupAndFTP.exe was using 50% of the CPU resources and was adversely affecting the performance of the server (a Windows 2003 server running MS SQL 2005).
I REALLY love the program but I cannot continue to run it under these circumstances. Any assistance is much appreciated.
Thanks!
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
Please check version 6.1.6.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 725
|
Sorry to jump in on thread:
Version 6.1.7.37794
Still same simptoms.
I'll add more details so it should be easily reproducable for you.
My instalation:
- I've created my own script that mounts share, runs SQLBackupAndFTP and removes share.
- Script is run via windows scheduler.
- runing the script shows simptoms, described above (program still runs after "completed" in log).
Script:
net use B: \\server\share password /user:DOMAIN\backupsql
"C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r "C:\Documents and Settings\Administrator\My Documents\SQL backup.jobx"
net use B: /d
exit
Computer that runs the script is obviusly not in domain, but uses domain user to mount share. Script is run by local admin.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
In automatic scripts like yours try using "-rn" SBF option instead of "-r":
net use B: \\server\share password /user:DOMAIN\backupsql
"C:\Program Files\SQLBackupAndFTP\SQLBackupAndFTP.exe" -rn "C:\Documents and Settings\Administrator\My Documents\SQL backup.jobx"
net use B: /d
exit
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 725
|
Thank you for suggestion! It fixed the problem.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 9/19/2011
Posts: 3
|
I am having a similar problem with the latest (free) version of SqlBackupAndFTP running on a Windows 2008 R2 Hyper-V server. I am not using any custom scripting - just the default backup of a database to an ftp server. The CPU and memory usage climb sky high over a period of days and then crash the server.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
What parameter -r or -rn is used in Windows Schedule for this job? What SBF version are you using?
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 9/19/2011
Posts: 3
|
I am using version 6.1.6.34242
I have not specified any parameters (how would I do so?) - I am just doing a task scheduled from within SQLBackupANDFTP using the "Schedule this Job" option.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 9/19/2011
Posts: 3
|
I just found the job in the task scheduler and it has the -rn parameter....
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
Could you please check if you have the same problem with the latest version 6.1.9?
|
|
|
|
|
