Hi,

I am running Adaptive Server Anywhere 9 (9.0.2.3593). What I need is to
setup off-site backup that will be updated on hourly basis with the most
recent data. It would have to copy data, stored procedures, views and
users/groups. Is there a tool for Sybase that would do what I am trying to
acomplish? Basically, the main requirement is to copy only new data as the
databases are 10GB+ and copying such big database every hour would be very
inefficient.

Thanks.

In short we provide the dbbackup utility for this purpose, you should
probably give this white paper a read before you start planning your
backup strategy to see what is best for you.

http://www.sybase.com/detail?id=47877


Drabina wrote:

"Drabina" <mpromo (AT) maurycy (DOT) com> wrote in news:4ac3b9a7$1@forums-1-dub of
sybase.public.sqlanywhere.general:

D> I am running Adaptive Server Anywhere 9 (9.0.2.3593). What I need is
D> to setup off-site backup that will be updated on hourly basis with
the
D> most recent data. It would have to copy data, stored procedures,
views
D> and users/groups. Is there a tool for Sybase that would do what I am
D> trying to acomplish? Basically, the main requirement is to copy only
D> new data as the databases are 10GB+ and copying such big database
D> every hour would be very inefficient.

I responded on the MobiLink newsgroup where I would encourage you to
continue this thread instead of here on the General newsgroup.

Here were the options presented:

You have a couple of choices depending on the LAN speed between the
remote locations.

1. You can perform incremental log backups and send the log to the
other machine.

2. You can use SQL Anywhere mirroring between the 2 servers /
locations.

3. You can use MobiLink between the 2 servers. Incidentally, under
this setup, the main server is the REMOTE and the backup site is
the CONSOLIDATED. This may seem backwards, but it is by far the
best way to set this up for performance.


Which option you choose depends on many different factors, which I
believe is best discussed around MobiLink and on the MobiLink forum.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng11 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase....ctDocumentList

Documentation
http://dcx.sybase.com/