Re: copy files while Backup Agent is running->error 46



This is a common problem, caused purely by timing (i.e. backup up the
file at the same time it is being opened), and simply a functional
defect in the design of the Backup Agent software. We have documented
this issue in previous posts and in our newsletter.

The solution, until Pervasive implements a "White List" feature for
Backup Agent, is to ensure that ALL files are open at the start of the
backup process. The Goldstar Software utility HOLDOPEN can work in
conjunction with the Backup Agent to force a given set of files to be
opened at the same time the Backup is started, thus ensuring that these
files are properly protected.

Optionally, you can use the BUTIL -STARTBU process to ensure that all
files are protected manually, without using Backup Agent. (It MAY be
possible to do both at the same time, but the order may be important to
prevent failures.)
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach@xxxxxxxxxxxxxxxxxxxx
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 11/13/2007 ***

nmm wrote:

Hi Btrivieans!

Bill Bach wrote as reply to the problm described at the end of ths
post:
I would definitely recommend upgrading to SP3 (v8.7) as the first
step.

Well, we do the upgrade and a couple of weeks there were no problms.
But yesterday we observe the following:

backup-agent was started exactly at 12:30 h, several datafiles where
at this moment not open especially a (btrieve-)file named pattest.dat.

While running PBA the datafiles are copied (with XCOPY). The copy job
lastes until 12:36 h. Meanwhile, at 12:33 h somebody used a function
of the application that needs pattest.dat, henceforce it was opened:
in the PBA-Log appear

I 1612 04.10.2007 12:33:34 Backup Agent is now ON for this file:
"D:\project\DATS\PATTEST.DAT"

the strange thing is, that just after this at we get Error 46 on
update and add-operations on that file pattest.dat (not on open or
read). This Error 46 comes for every update/add until 12:59(! yes
59!) although the PBA was OFF since 12:26 (as listed in the
Log-File). The PBA is swiched off not before the copy-action is
finished (so the copy was ready at 12:26.).

There were also other btrieve-files opened at 12:33:34, but with them
no problem occur.

I can not explain this behavior. I guess, that at the moment of
switching PBA on for pattest.dat (12:33:34) the copy of that file was
just in progress. But than the error should be gone at leasat at
12:36. But eaven if the error hat gone at 12:36 it remains the
question: why occur this error in the first place? I thgought, that
PBA will tolerate copiing of the originalfiles while running?

(of course *.^^^are not copied!).

As far as I know, the virusscanner is configured, so that *.dat and
*.^^^ are not scanned.

(In the PVSW.LOG file is nothing this time.)

Do you have any idea, what happens?

Sincerely
Mircea






Hallo Btrivieans!

since a couple of weeks we observe, that sometimes - not ever - PSQL
engine 8.1 stops while Backup Agent is switched off:
Backup Agent runs twice a day, 12:30 and 20:00 a clock. Many times it
work without problm, but sometimes for some reasen I dont konow, the
PSQL engine simple stop work: here whats in the pvsw.log-file


07-10-2007 12:35:58 W3CACHE 00000620 W3DBSMGR.EXE TKHSERV
I MicroKernel is using default settings.
07-10-2007 12:35:59 W3CACHE 00000620 W3DBSMGR.EXE TKHSERV
W Resources allocated
07-10-2007 12:36:38 W3CACHE 00000620 W3DBSMGR.EXE TKHSERV
I Resources released


(entries before 12:35:58 are not from 07-10-2007!)

(We have already exclude the btrieve-datafiles from virus-scanning.)

Is this phenomenon known? Will it make sense to update to 8.6 (i.e.
is it a known issus in 8.1)?


Any hint will be welcome

Regards
Mircea



--

.



Relevant Pages

  • Re: Backup Agent
    ... Bill / Michael ... I think we will then use BUTIL and save the money for the backup agent. ... Create a batch file that runs immediately after your PVBACKUP -ON command that causes all of the "critical" Btrieve files to be opened. ... If we now start the Backup Agent, no files are set to continuous operation which is ok. ...
    (comp.databases.btrieve)
  • Re: Event Error
    ... MSSQL$BKUPEXEC server they said I could un-select the backup agent for it ... Tim ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Backup Agent
    ... Backup Agent suffers horribly from the absence of a "white list", or a way to force a given set of files open. ... Our application is using Pervasive Data Provider for .NET and database files are just opened if needed, meaning the database files are NOT constantly open. ... Now assuming the backup software starts backup for a large database file opening the file in read/write mode - now our application opens this file and Backup Agent tries to set it into continuous operation - this will fail because the file is already opened by the backup software. ...
    (comp.databases.btrieve)
  • Re: Why use a backup agent?
    ... You don't need a Backup Agent to back up SQL Server. ... Native backup combined with a typical tape backup has worked fine for me. ...
    (microsoft.public.sqlserver.server)
  • Re: Brightstor Arcserve 9 Exchange Agent MAPI error
    ... I restarted the CA BrightStor Backup Agent RPC Server and thne I could ... I restart the following services; ...
    (microsoft.public.exchange2000.admin)