|
Home > Archive > SQL Anywhere database > August 2005 > Problems with backup event
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Problems with backup event
|
|
| Djbird 2005-08-24, 1:23 pm |
| Running a procedure each evening to backup a version 8.02
sybase database, works fine for months on end, then fails to
work for a number of days looking in the log file there is
no failure or error code and the event simply appears to not
even have triggered. Any ideas of cause and resolution?
| |
| Randy Jheeta 2005-08-24, 1:23 pm |
| <Djbird> wrote in message news:430ca01c.1157.1681692777@sybase.com...
> Running a procedure each evening to backup a version 8.02
> sybase database, works fine for months on end, then fails to
> work for a number of days looking in the log file there is
> no failure or error code and the event simply appears to not
> even have triggered. Any ideas of cause and resolution?
Maybe add an exception clause to your backup procedure and see if an
exception is thrown (check SQLCODE and SQLSTATE)
Are transactions still being logged to the transaction log?
Turn request level logging on, (-zr all switch on server) and see what is
logged after the BACKUP DATABASE statement is called.
|
|
|
|
|