Not backing up complete database


#1

I’m running SQL Backup and FTP Version 12.2.11 on 2 different computers. I had been running a version from 2014. The older version worked fine. When I upgraded to the new version, one of the systems works fine, the other has a problem in that it doesn’t back up the complete SQL database.

Below is the latest log from “SCOTT” which shows a complete backup of 439MB.
There is also a log from “Natalie-HP” showing a backup of 894KB.
Both database are about the same size, yet Natalie-HP is not backing up the whole database.

The differences appear to be that SCOTT is running SQL Server: 2012 RTM Express Edition while Natalie-HP is running SQL Server: 2012 SP4 Express Edition. I’ve also provided versions on several other programs involved in the backup.

Anybody have any ideas??

SQL Backup and FTP
Version 12.2.11

SCOTT

1/7/2020 11:14 PM Your Professional Trial license expires in 6 day and will be converted to Free automatically. ${https://sqlbackupandftp.com/buy|Purchase a license} to continue with your backups uninterrupted.
1/7/2020 11:14 PM Starting job “GoldMine Backup.jobx” - “Full”. Computer “SCOTT”. Account “SYSTEM@DAHNE”. App v.“12.2.11”.
1/7/2020 11:14 PM Connecting to SQL Server: 2012 RTM Express Edition (64-bit). SCOTT\SQLEXPRESS
1/7/2020 11:14 PM The backup folder “C:\Data\Goldmine SQL Backups” has “141.879GB” free space. The temporary folder “C:\Data\Goldmine SQL Backups” has “141.879GB” free space
1/7/2020 11:14 PM Backing up “SCOTT\SQLEXPRESS” SQL Server databases
1/7/2020 11:14 PM Getting maximum file size…
1/7/2020 11:14 PM The maximum file size: “”
1/7/2020 11:14 PM Backing up “goldmine” database to .bak file. Backup type: “Full”. Checksum: “Disabled”.
1/7/2020 11:14 PM “goldmine” database backup successfully completed. Backup type: “Full”.
1/7/2020 11:14 PM Database “goldmine” successfully backed up to “goldmine202001071614.bak : 2.219GB”
1/7/2020 11:14 PM Compressing “goldmine202001071614.bak” file with Internal archiver. Encryption: “Off”
1/7/2020 11:15 PM Backup of “goldmine” successfully compressed to “(goldmine202001071614.zip : 439.702MB)”
1/7/2020 11:15 PM Connecting to Folder destination “C:\Data\Goldmine SQL Backups”
1/7/2020 11:15 PM Reading folder information by path: “C:\Data\Goldmine SQL Backups”
1/7/2020 11:15 PM The current destination folder is “C:\Data\Goldmine SQL Backups”
1/7/2020 11:15 PM Sending backup of “goldmine” to Folder destination “C:\Data\Goldmine SQL Backups”
1/7/2020 11:15 PM Uploading local “goldmine202001071614.zip” to remote “goldmine202001071614.zip” in folder “C:\Data\Goldmine SQL Backups”
1/7/2020 11:15 PM Uploaded 100 % (average speed = 5.1 GB/s)
1/7/2020 11:15 PM Cleaning up backups of “GoldMine Backup.jobx” job
1/7/2020 11:15 PM Cleaning up backups of “goldmine” database at Folder destination “C:\Data\Goldmine SQL Backups”
1/7/2020 11:15 PM Cleaning up “C:\Data\Goldmine SQL Backups” folder
1/7/2020 11:15 PM Deleting old backup of “goldmine”. Backup type: “Full”. Backup time: “01/03/2020 19:01:19”. Files: “goldmine202001031900.zip”
1/7/2020 11:15 PM Disconnecting from Folder destination “C:\Data\Goldmine SQL Backups”
1/7/2020 11:15 PM Job “GoldMine Backup.jobx” finished

Microsoft SQL Server Management Studio 11.0.2100.60
Microsoft Data Access Components (MDAC) 10.0.18362.1
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.18362.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.18363

msxml3.dll 8.110.18362.239
msxml6.dll 6.30.18362.418

NATALIE

1/7/2020 11:17 PM Starting job "Backup Job - 1 " - “Full”. Computer “NATALIE-HP”. Account “SYSTEM@DAHNE”. App v.“12.2.11”.
1/7/2020 11:17 PM Connecting to SQL Server: 2012 SP4 Express Edition (64-bit). Natalie-HP\SQLEXPRESS
1/7/2020 11:17 PM The backup folder “C:\Data\Goldmine SQL Backups” has “86.458GB” free space. The temporary folder “C:\Data\Goldmine SQL Backups” has “86.458GB” free space
1/7/2020 11:17 PM Backing up “Natalie-HP\SQLEXPRESS” SQL Server databases
1/7/2020 11:17 PM Getting maximum file size…
1/7/2020 11:17 PM The maximum file size: “”
1/7/2020 11:17 PM Backing up “Goldmine” database to .bak file. Backup type: “Full”. Checksum: “Disabled”.
1/7/2020 11:17 PM “Goldmine” database backup successfully completed. Backup type: “Full”.
1/7/2020 11:17 PM Database “Goldmine” successfully backed up to “Goldmine202001071617.bak : 9.968MB”
1/7/2020 11:17 PM Compressing “Goldmine202001071617.bak” file with Internal archiver. Encryption: “Off”
1/7/2020 11:17 PM Backup of “Goldmine” successfully compressed to “(Goldmine202001071617.zip : 894.439KB)”
1/7/2020 11:17 PM Connecting to Folder destination “C:\Data\Goldmine SQL Backups”
1/7/2020 11:17 PM Reading folder information by path: “C:\Data\Goldmine SQL Backups”
1/7/2020 11:17 PM The current destination folder is “C:\Data\Goldmine SQL Backups”
1/7/2020 11:17 PM Sending backup of “Goldmine” to Folder destination “C:\Data\Goldmine SQL Backups”
1/7/2020 11:17 PM Uploading local “Goldmine202001071617.zip” to remote “Goldmine202001071617.zip” in folder “C:\Data\Goldmine SQL Backups”
1/7/2020 11:17 PM Uploaded 100 % (average speed = 24.3 MB/s)
1/7/2020 11:17 PM Cleaning up backups of "Backup Job - 1 " job
1/7/2020 11:17 PM Cleaning up backups of “Goldmine” database at Folder destination “C:\Data\Goldmine SQL Backups”
1/7/2020 11:17 PM Disconnecting from Folder destination “C:\Data\Goldmine SQL Backups”
1/7/2020 11:17 PM Job "Backup Job - 1 " finished

Microsoft SQL Server Management Studio 11.0.7001.0
Microsoft Data Access Components (MDAC) 10.0.18362.1
Microsoft MSXML 3.0 4.0 6.0
Microsoft Internet Explorer 9.11.18362.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.18363

msxml3.dll 8.110.18362.239
msxml6.dll 6.30.18362.418


#2

Hi Scott_Dahne,

Thank you for your reply.

Could you please try to perform a backup of the database, which backup is small, via SQL Server Management Studio (SSMS), and compare the size of the backup that was made via SSMS and SQLBackupAndFTP?

Sorry for the inconvenience.