Hi all.
I have a ASA server using dbsvr8.exe. The problem: I have
configured a service on Sybase Central tool in the Events
module on the database. Into this module, there is a event
called "BackupManana" running every day at 6:00 am with this
command: "BACKUP DATABASE DIRECTORY
'D:\\SW\\Backups\\Manana' TRANSACTION LOG TRUNCATE".
The task run every day, but the data into the tables are
from 20 days before. It is wrong. I can`t understand why.
How can I do a database backup without down the server
service ?

Thanks for help.

JorgeG

I recommend using dbbackup.exe instead of the BACKUP command because
it is far easier to set up a batch file that keeps a COMPLETE RECORD
of the success and/or failure of every single backup attempt, and you
can use Windows Scheduled Tasks to set up a schedule.

The BACKUP command is great for embedded databases where you want
everything buried from user view BUT it is harder to do a lot of
things that are easy in batch files.

Anyway, have a look at this post, the code was written for Version 11
but it may not require much work to change it to work with Version 8:

http://sqlanywhere.blogspot.com/2009...revisited.html

At the very least, this command...

"%SQLANY11%\bin32\dbbackup.exe"^
-c "ENG=ddd11;DBN=ddd11;UID=dba;PWD=sql"^
-o bkup\dbbackup_log.txt -x -y bkup\generation_temp

will have to change, possibly to this (UNTESTED):

"%ASANY8%\win32\dbbackup.exe"^
-c "ENG=ddd11;DBN=ddd11;UID=dba;PWD=sql"^
-o bkup\dbbackup_log.txt -x -y bkup\generation_temp

Plus, any changes you want to make to have dbbackup behave
differently; see the Help on dbbackup for more information.

Breck


On 20 Jan 2010 11:00:18 -0800, Jgucani wrote:

--
Breck Carter - Blog: http://sqlanywhere.blogspot.com/

SQLA questions and answers: http://sqla.stackexchange.com

RisingRoad helps SQL Anywhere developers make better databases
http://www.risingroad.com/
Breck.Carter at gmail