dbTalk Databases Forums  

Re: backup failing occasionally

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Re: backup failing occasionally in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Alex Whitney
 
Posts: n/a

Default Re: backup failing occasionally - 09-02-2010 , 11:13 AM






They do have a virus scanner that we are not familier with running (Panda).

We will try this.

Thanks

Alex
"John Smirnios [Sybase]" <smirnios_at_sybase.com> wrote

Quote:
My suspicion would be an interaction with a virus scanner. File deletions
can complete successfully on Windows but an immediate subsequent attempt
to create a file by the same name gets an "ERROR_DELETE_PENDING" --
usually caused by a virus scanner holding onto the file for a short while.
In some places in the server code, we have worked around that nonsense;
however, I doubt it was done in v9 and perhaps that particular instance of
the problem was missed. Try renaming the old file then deleting it then
running your new backup.

John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer


On 8/31/2010 6:22 PM, Alex Whitney wrote:
ABout once every two weeks, on one of our customers servers, the backup
process starts and immediately ends with the following messages:

'Unable to create backup file "D:\EMR\database\backup\emr.db"'

'Database backup failed'

There is no emr.db file in the backup directory after this occurs (it
appears to delete the original one from the previous backup)

There are no messages in the console log at this time either.

We have looked for other processes that might be running at this that
could
be interfering but do not see anything. There is sufficcient disk space.



ASA 9.0.2.3508

OS 2003 64 bit standard SP2

database size is 47 GB.

Alex


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.