Full Backup Smaller than expected


#1

Hi,

If I make up backup of a database with SQL Managment Studio it is about 4.2 gb with SQl after unzipping it it is 2.3gb.
I tried to review my settings on this page but it does not seem to work I have tried 4 different browsers https://sqlbak.com/academy/full-backup/

I have full backup ticked, Un ticked, Dif, Folder and Transaction log?

I am backing up to a Nas and the backup log says all is well any ideas.

19/09/2019 12:25 PM Starting job “Oliver Backup.jobx” - “Full”. Computer “E5070S01SV012”. App v.“12.2.9”
19/09/2019 12:25 PM Connecting to SQL Server: 2008 R2 SP2 Express Edition with Advanced Services (64-bit). (default)
19/09/2019 12:25 PM The backup folder “e:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup” has “756.913GB” free space. The temporary folder “C:\Users\Administrator\AppData\Local\Temp\Pranas.NET\SQLBackupAndFTP\backup” has “135.523GB” free space
19/09/2019 12:25 PM Backing up “(default)” SQL Server databases
19/09/2019 12:25 PM Getting maximum file size…
19/09/2019 12:25 PM The maximum file size: “”
19/09/2019 12:25 PM Backing up “ReportServer” database to .bak file. Backup type: “Full”. Checksum: “Disabled”
19/09/2019 12:25 PM “ReportServer” database backup successfully completed. Backup type: “Full”
19/09/2019 12:25 PM Database “ReportServer” successfully backed up to “ReportServer201909191225.bak : 30.835MB”
19/09/2019 12:25 PM Compressing “ReportServer201909191225.bak” file with Internal archiver. Encryption: “Off”
19/09/2019 12:25 PM Backup of “ReportServer” successfully compressed to “(ReportServer201909191225.zip : 7.096MB)”
19/09/2019 12:25 PM Backing up “oliver” database to .bak file. Backup type: “Full”. Checksum: “Disabled”
19/09/2019 12:26 PM “oliver” database backup successfully completed. Backup type: “Full”
19/09/2019 12:26 PM Database “oliver” successfully backed up to “oliver201909191225.bak : 2.027GB”
19/09/2019 12:26 PM Compressing “oliver201909191225.bak” file with Internal archiver. Encryption: “Off”
19/09/2019 12:28 PM Backup of “oliver” successfully compressed to “(oliver201909191225.zip : 473.308MB)”
19/09/2019 12:28 PM Connecting to Folder destination “\10.225.9.69\Public\Library Backup”
19/09/2019 12:28 PM Reading folder information by path: “\10.225.9.69\Public\Library Backup”
19/09/2019 12:28 PM The current destination folder is “\10.225.9.69\Public\Library Backup”
19/09/2019 12:28 PM Sending backup of “ReportServer” to Folder destination “\10.225.9.69\Public\Library Backup”
19/09/2019 12:28 PM Uploading local “ReportServer201909191225.zip” to remote “ReportServer201909191225.zip” in folder “\10.225.9.69\Public\Library Backup”
19/09/2019 12:28 PM Uploaded 100 % (average speed = 8.7 MB/s)
19/09/2019 12:28 PM Verifying remote file “ReportServer201909191225.zip” with local one “ReportServer201909191225.zip”
19/09/2019 12:28 PM Sending backup of “oliver” to Folder destination “\10.225.9.69\Public\Library Backup”
19/09/2019 12:28 PM Uploading local “oliver201909191225.zip” to remote “oliver201909191225.zip” in folder “\10.225.9.69\Public\Library Backup”
19/09/2019 12:29 PM Uploaded 100 % (average speed = 10.4 MB/s)
19/09/2019 12:29 PM Verifying remote file “oliver201909191225.zip” with local one “oliver201909191225.zip”
19/09/2019 12:29 PM Cleaning up backups of “Oliver Backup.jobx” job
19/09/2019 12:29 PM Cleaning up backups of “ReportServer” database at Folder destination “\10.225.9.69\Public\Library Backup”
19/09/2019 12:29 PM Cleaning up backups of “oliver” database at Folder destination “\10.225.9.69\Public\Library Backup”
19/09/2019 12:29 PM Disconnecting from Folder destination “\10.225.9.69\Public\Library Backup”
19/09/2019 12:29 PM Job “Oliver Backup.jobx” finished


#2

Larry_Youngman

To investigate this case, we need more details. Could you please click on the “Script” button and send us the details. To make them private please send them to support@sqlbackupandftp.com

Sorry for the inconvenience.