Re: Strang behavior of Backup-Agent 1.0

This posting has been simmering in the back of my head for ... it
looks like two weeks now.

First it appears from the batch file that you start backup mode, make
a backup, stop backup mode then make another copy of the data ON TOP
OF the backup that was just made thus wiping out the good backup.

Second, even if I didn't figure out the paths correctly on the first
point, you should not make a backup, particularly with a plain OS file
copy while the data files are not in backup mode. It can can cause
file locking issues with the database engine.

Leonard

On Sun, 05 Feb 2006 10:16:53 -0600, "Bill Bach"
<goldstar@xxxxxxxxxxxxx> wrote:

The Backup Agent is simply using the "Continuous Operations Mode" of
the database. When the ENDBU is received by the engine, the engine
confirms that all files will start the roll-in process (wherein all
changes are rolled out of the delta files into the live files again).

The problem is that this process is ALSO running in tandem with a live
system. While the changes are being rolled back to the live files, new
changes may be recorded at the Delta file -- making the process take
longer. In fact, this roll-in process can easily take in excess of
minutes and even hours in some very busy systems. (Indeed, I've seen
cases of heavily-written files that NEVER can catch up!)

Because of this, the PVBACKUP -OFF cannot be tied to the completion of
the roll-in process, and the only way to ensure that the roll-in is
complete is to wait until all deltas disappear.

Having said that, there are two solutions:

1) Exclude the Delta files from your last XCOPY. This is MUCH easier.
BTW, you may also wish to experiment with XXCOPY or ROBOCOPY -- two
XCOPY replacements that are much more powerful, and that only copy
files that have been changed. These tools can complete the copy job
much faster, with less wear & tear on the HD.

2) Add code in the batch file to loop on the delta files. Something
like:
:Loop
SLEEP 10
IF EXIST *.^^^^^^ GOTO Loop
Note that you must have the SLEEP command in your search path. Also,
note that since the ^ is an escape character for DOS, you must double
it. You can see this if you try a simple "DIR *.^^^" command, which
doesn't work.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach@xxxxxxxxxxxxxxxxxxxx
http://www.goldstarsoftware.com
*** Sydney: Pervasive.SQL Service & Support Class - 02/27/06 ***
*** Chicago: Pervasive.SQL Service & Support Class - 03/27/06 ***


nmm wrote:

Hallo Btrivieans!

we observed an odd behavior of Backup-Agent (may be we do something
wrong?)

Its on a Windows 2003-Server, running Pervasive SQL 8.6 und
Backupagent 1.0.

We run a Batch like the following (via taskmanager, every day at
22:00 o clock)


1 if not exist C:\PVSW\PBA\bin\ohnedats.txt goto error
2 C:\PVSW\PBA\bin\pvbackup.exe -on
3 xcopy f:\projekt\dats\*.dat g:\backup\projekt\dats\ /E /V /Y /R
4 xcopy f:\projekt\logs\*.log g:\backup\projekt\logs\ /E /V /Y /R
5 xcopy f:\projekt\*.dat g:\backup\projekt\ /V /Y /R
6 C:\PVSW\PBA\bin\pvbackup.exe -off
7 xcopy f:\projekt\*.* g:\backup\projekt\
/EXCLUDE:C:\PVSW\PBA\bin\ohnedats.txt /E /V /Y /R 8 :error

ohnedats.txt contains:
--------schnipp-------------
\dats\
alllog.dat
msglog.dat
lastlog.dat
\logs\
--------schnapp-------------


Usually this works fine, but sometimes (no systematic recognizable)
the xcopy in line 7 still finds *.^^^-files. This is strange,
because the "pvbackup.exe -off" is logged as completes sucessfully.

It looks like, that the command "pvbackup.exe -off" returns too
early (before compeeting its job).

We helped ourselfs by inserting some delay (using somthing like
"ping -n 1 -w 60000 1.1.1.1" = waite 60 Sec) after lines 2 and 7, but
this is not satisfactory.

Does anyone know, why pvbackup returns so early or if one can tell it
not to return befor finishing?

Any comment will be wellcome!

Best reagrds from Jena,

M. Malarski

.

Relevant Pages

  • Re: Strang behavior of Backup-Agent 1.0
    ... The Backup Agent is simply using the "Continuous Operations Mode" of ... When the ENDBU is received by the engine, ... confirms that all files will start the roll-in process (wherein all ... Exclude the Delta files from your last XCOPY. ...
    (comp.databases.btrieve)
  • Re: Strang behavior of Backup-Agent 1.0
    ... After switching backup mode off, I copy only files that are not affected by the ... file locking issues with the database engine. ... confirms that all files will start the roll-in process (wherein all ... Exclude the Delta files from your last XCOPY. ...
    (comp.databases.btrieve)
  • Re: Schedule Batch File-How to?
    ... backup with your Robobkup program. ... Panel> Scheduled Task etc. and the batch file name was used as the ... Windows command that you are using within the batch file. ... The properties window for the new scheduled task should now be open. ...
    (microsoft.public.windowsxp.general)
  • Using Print Migrator
    ... TCP/IP port and latest drivers from the internet. ... tool to Backup the printer information to a .cab file. ... batch file and put this in a shared folder. ... place this file in the .cab file that the tool creates. ...
    (microsoft.public.win2000.printing)
  • Re: How can I easily back up to an external hard drive?
    ... Easiest way to do this is to create a batch file and use the XCOPY command ... This may be overridden with /-Y on the command line. ... Documents & Settings folder that you use to sign in with. ... My batch file to backup my primary desktop to my server's backup drive is: ...
    (microsoft.public.windowsxp.help_and_support)