Goodmorning everyone,
I have a problem with the latest versions of the software. When I send the compressed DB to an FTP server, it does not exceed 50 KB/s of speed.
Also known is an unusual use of storage by the SBAF process.
For example, if I send to the FTP server through FileZilla, I use all the bandwidth in UP without any problems.
13:13:01 : Starting scheduled job “backup.jobx” with backup type “Full”. The computer name: “SERVER”. The application version: “11.2.0”
13:13:02 : The backup folder of the job is “D:\MSSQL\Backup” with “351,714GB” free space. The temporary folder of the job is “C:\Users\user\AppData\Local\Temp\Pranas.NET\SQLBackupAndFTP\backup” with “68,627GB” free space
13:13:03 : Backing up “.\SQLEXPRESS” SQL Server databases
13:13:03 : Getting maximum file size…
13:13:03 : The maximum file size: “”
13:13:03 : Backing up “euro2000” database to .bak file. Backup type: “Full”. Checksum: “Disabled”
13:14:00 : “euro2000” database backup successfully completed. Backup type: “Full”
13:14:01 : Database “euro2000” has been successfully backed up to “euro2000201709221313.bak : 1,872GB”
13:14:01 : Compressing “euro2000201709221313.bak” file with Internal archiver. Encryption: “Off”
13:15:52 : Backup of “euro2000” has been successfully compressed to “(euro2000201709221313.zip : 178,108MB)”
13:15:53 : Connecting to Folder destination “D:\BACKUP_EURO”
13:15:53 : Reading folder information by path: “D:\BACKUP_EURO”
13:15:53 : The current folder of the destination is “D:\BACKUP_EURO”
13:15:54 : Sending backup of “euro2000” to Folder destination “D:\BACKUP_EURO”
13:15:54 : Uploading the local file “euro2000201709221313.zip” into a remote file “euro2000201709221313.zip”
13:15:57 : Uploaded 100 % (average speed = 63,7 MB/s)
13:15:59 : Verifying remote file “euro2000201709221313.zip” with local one “euro2000201709221313.zip”
13:16:01 : Connecting to FTP destination “silver.solidspace.org”
13:16:01 : The current folder of the destination is “/”
13:16:02 : Sending backup of “euro2000” to FTP destination “domain.org”
13:16:02 : Uploading the local file “euro2000201709221313.zip” into a remote file “euro2000201709221313.zip”
13:16:08 : Uploaded 100 % (average speed = 52,4 KB/s)
14:14:04 : Verifying remote file “euro2000201709221313.zip” with local one “euro2000201709221313.zip”
14:14:05 : Disconnecting from FTP destination “domain.org”
14:14:05 : Cleaning up backups of “SQLeuro2000backup.jobx” job
14:14:05 : Cleaning up backups of “euro2000” database at Folder destination “D:\BACKUP_EURO”
14:14:06 : Cleaning up “D:\BACKUP_EURO” folder
14:14:06 : Deleting old backup of “euro2000”. Backup type: “Full”. Backup time: “09/15/2017 13:16:06”. Files: “euro2000201709151313.zip”
14:14:07 : Cleaning up backups of “euro2000” database at FTP destination “silver.solidspace.org”
14:14:08 : Disconnecting from Folder destination “D:\BACKUP_EURO”
14:14:09 : Job “SQLeuro2000backup.jobx” finished
I’m facing the same issue, but it caps at about 10 mbit/s
using another ftp client on the server and transfering the same files (also using the same SFTP methods) is at about 250mbits. What could limit it in SQLBackupAndFtp?
As soon as I close the application it slows down to 10 mbit/s (running from the background windows service then). When I reopen SQLBackupAndFtp it’s back to full speed. What is going on?
SQLBackupAndFTP always uploads a file to a destination using the windows service. When you open SQLBackupAndFTP application, the application just monitors your jobs using duplex channels.