Using sqlanywhere 12, we run a full dbbackup daily, with -x option to truncate the active log. The backup is run on the same server, compressed, and ftp'd to a secondary server.
We want to add a continuous live backup to the secondary server, to cover the period between full backups.
When the full backup runs, the live backup stops[EDIT: the live backup continues and the live log is truncated and restarted] (because active log is truncated).
Is there a way to automatically restart the live log backup? [EDIT: It restarts automatically. How can we avoid losing the content of the live log when it is truncated? Surely we want to keep it until the new backup reaches the secondary server?]
The live backup is working exactly as designed here. A live backup's job is to keep a live copy of the active transaction log. When you perform your full backup (and I assume rename+restart the active transaction log), that will cause the transaction log being maintained by the live backup to also be truncated. There is no option to delay the truncation of the transaction log being being maintained by the live backup while an external process does "something", which in this case is compressing + FTPing the backup.
answered 11 Feb '13, 15:23
EDIT: I have turned that previous comment onto the question into an answer and I hope the experts like Reg will confirm the following:
In my understanding, you should be able to do the following at the secondary site:
So, that way you could "freshen" your secondary site during the day.
Note, however, that for a second "refresh", you will have to start with the full bakup again, i.e. it should not be possible to "freshen" the database from step 7 with an more current live backup log, as that log fits to the active database, and not to the restored and already "freshend" one.
So, in case the primary site goes down, you now have three options:
Option 1 is the normal usage of a live backup log, so I can't tell whether options 2 or 3 would be useful for you...
No, I have never used that technique myself.