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