Difference in Size of SQL Server 2008 R2 backup on Local disk and on Remote Network Share I wanted to take backups of all SQL Server 2008 R2 databases on a network share, I already  have a backup schedule for backup on local disk. I have tried two methods:


using SQLBackupAndFTP Software
using SQL Server 2008 R2 maintenance Job 


Using both above methods for the backup on network drive, there is hell a lot of difference of the size of data as compared to backup on local disk. Please see details below

Backup of data using SQL Server 2008 R2 Scheduler:

When I took the backup of the data using the SQL Server 2008 R2 scheduler 


The size of the data was almost 10.5 GB.
The number of files that were backup were 30 items/files


Backup of data using SQLBackupAndFTP software:

When I took the backup of the data using the SQL Server 2008 R2 scheduler 


The size of the data was almost 822 MB.
The number of files that were backup were 28 items/files


I really wonder what has been done, the backup files in both cases have extension .bak and no compression is done.

Backup of data using SQL Sserver 2008 R2 on Local Disk and on Network Share:

I then configured two jobs:


One for backup on the local disk drive
One for the backup on the network share


To my surprise, there is still difference of Size in data and files, please see screen shots below. I really wonder what is happening and why is there so much difference in the size of data.

Any body has any idea, please feel free to comment and share your knowledge.
You say you are "using SQLDATABACKUPANDFTP Software" if this software is from http://sqlbackupandftp.com/ then it says it "Zips, Encrypts and FTPs the database backups" which would explain much of the difference.

I'm afraid your screenshots didn't appear so I can't comment on the other difference.