Hi,
I’m using version 12.7.35 to backup remote SQL Server databases into script files. This always worked fine, but all of a sudden became significantly slower, not in proportion with the growth of the database.
What used to take 20 minutes now takes up to 3 hours!
After several investigations I discovered something strange:
Generating the script and downloading it to the local PC took 2h55 using SQLBackupAndFTP, while the same activities using Microsofft SQL Server Management Studio only took 9m30
Same PC, same server, same database, the SSMS backup done immediately after the SQLBackupAndFTP was finished, so similar network traffic. The resulting script file has exactly the same size. (7.6 GB)
What can be done to reduce the overhead in SQLBackupAndFTP that causes the backup to be so much slower than the SSMS one? I can live with 2-3 times slower, but 15-20 times is problematic.
Thanks in advance,
Erwin