Backing Up Running Database 1

[tenbobmillionaire]

I am running SQL Anywhere v5.5. Currently I manually back up the databases (which are always running) using Sybase Central backup facility. Does anyone have an easy way to automate this ie. some batch file/script/stored procedure,and schedule it to run every hour or whatever?
I am not that familiar with programming procedures etc in the DB but if someone could point me in the right direction I will give it a go.
Thanks
Mick

 

[DBAguy]

If this is running on NT you could put the following in a sql file:

dump database <database_name> to &quot;c:\temp\database.dump&quot;

so if you say this in file dbdump.sql for example you could get something like AT to run:

isql -Usa -Pxxxx -Sxxxx -i dbdump.sql

this will login to the db and execute the SQL to dump the specific database

A