Subject rsync - differential backup
Author m2data
Hi all

Is there anyone with experience using rsync on windows?

I would like to transfer our backupfile (gbak) to a remote location.
The database size is >2G and it is mostly inserts and (almost) never
deletes. The database countains alot of medical JPG/PNG images and for
security reasons I cannot store the imagefiles external.

Now, I know that rsync uses MD5 fingerprints and a weak rolling
checksum. The weak rolling checksum catches the problem where I fx.
shifts every byte one or more bytes (bytes 0 becomes byte 4, byte 1
becomes 5).

I would like to program my own rsync clone, but at the same time it
would be nice to use MD5 alone. If I could use MD5 on the live
database I could make MD5 fingerprints on a block size equal to the
database page size. But the problem is that I cannot backup a live
database when ibserver/fbserver is running (shame on those that do!).

What about NBackup/fb2.0 (Nickolai Samofatov)? Could NBackup run MD5
during backup when the destination file already exists and only
transfer changed pages! I don't want incremental backup, I want
differential backup!

Brian Vraamark
2M-Data ApS