Subject | rsync - differential backup |
---|---|
Author | m2data |
Post date | 2004-06-18T07:20:27Z |
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
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