SQL Anywhere database replication

Author

DBBackup

Thomas Kehl

2005-09-11, 7:23 am

Hi.

I'm evaluating SQLRemote. Now, I have a question:
SQLRemote works with the transactionLog-Files. Now, we are using dbbackup
with -n and -r. Can anyone tell me, if SQLRemote works too, when we save the
db and start new transaction-log?

Thanks
Thomas

David Fishburn

2005-09-12, 11:23 am

"Thomas Kehl" <t.kehl (at) heeb.com> wrote in
news:4324045d$1@foru
ms-1-dub of sybase.public.sqlanywhere.replication:

> I'm evaluating SQLRemote. Now, I have a question:
> SQLRemote works with the transactionLog-Files. Now, we are using
> dbbackup with -n and -r. Can anyone tell me, if SQLRemote works too,
> when we save the db and start new transaction-log?

Yes, as you know, you never use dbbackup -x (truncate).
You have 3 choices:
1. dbremote -x (which rename the log everytime dbremote runs).
2. dbremote -x 5m (which rename the log when it exceeds 5M).
3. dbbackup -r (which rename the log not truncate it).

Then you must read these sections:

ASA Database Administration Guide
Database Options
Alphabetical list of options
DELETE_OLD_LOGS option [replication]

ASA Database Administration Guide
Replicating Data with Replication Server
Using the LTM
Transaction log and backup management
Using the DELETE_OLD_LOGS option

--
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 (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

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

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Sponsored Links