Subject Re: [firebird-support] rsync - differential backup
Author Jaume Sabater
m2data wrote:

> 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.

As far as the file is not being used by the database server, you will
have no problem. How efficient it will be is just another thing (not as
much as it could be, as you stated in your email).

I am using rsync on Linux boxes and never had any trouble. Nevertheless,
I bzip2 the gbak file before rsyncing, as it reduces its size more than
ten times (yes, I know that then rsync becomes just a "copy" tool, but
it's fast anyway).

Rsyncing Oracle databases is also a bad idea. In general terms, rsyncing
databases is quite unuseful (and dangerous some times).

--
Jaume Sabater
http://linuxsilo.net

"Ubi sapientas ibi libertas"