I'm using rsync to mirror my samba servers to a offsite linux box via an vDSL Internet link. No worries here. Our daily changes in these files are to small to trigger the daily quota of the link.
Now I'm trying to do the same with MSSQL Backups... i tried rsyncing .bak files. the problem is that if i choose to overwrite the files with a new backup the entire new backup is copied over... the same happens if i use Datebase Publishing wizard to dump .sql files. rsync thinks that the overwrites are entirely new files and copies them as new files (instead of just copy what changed) the problem is that in both cases (SQL Server Management Studio and Database Publishing Wizard) the files gets deleted/rewritten and not overwritten...
is there a simple way to create incrementing backups to a file that rsync recognizes as "things have been added" and not as entirely new files?
thanks for any help!