ASE Database forum - Full and Incremental Backups Using Event System

Author

Full and Incremental Backups Using Event System

molonede

2005-04-27, 11:24 am

I'm looking for assistance in reviewing the setup of a
Sybase Backup that was configured using the Create Event
statement. I believe our vendor configured the system using
the below commands. I need to get the basics on reviewing
the Event system for failures and to assure us that the
event system is properly configured. I would prefer to
have it Log a failure message in the Windows Application
Event log when a failure occurs.

I am interested in finding out more about how this backup
system works.

CREATE EVENT DBBackup
SCHEDULE DBBackup
START TIME '1:30AM' EVERY 24 HOURS START DATE 'Jun 22, 2001'
HANDLER
begin
backup database directory '\\\\ServerName\\Bac
kup\\Full'
transaction log truncate
end

CREATE EVENT LogBackup
SCHEDULE LogBackup
BETWEEN '6:05AM' AND '6:05PM' EVERY 2 HOURS START DATE 'Jun
22, 2001'
HANDLER
begin
backup database directory '\\\\ServerName\\Bac
kup\\Log'
transaction log only
end

Michael Peppler

2005-04-28, 8:26 pm

On Wed, 27 Apr 2005 07:55:59 -0700, molonede wrote:

> I'm looking for assistance in reviewing the setup of a Sybase Backup that
> was configured using the Create Event statement.

That looks like a ASAnywhere command - in which case you probably want to
post to one of the SQL Anywhere groups (sybase.public.sqlanywhere.*)

Michael
--
Michael Peppler [TeamSybase] mpeppler@peppler.org - http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html

Sponsored Links