Solved

Backing up open Btrieve-Files

Posted on 1998-10-16
5
494 Views
Last Modified: 2008-03-04
Any Idea how to update several open btrieve-files?
Version-Info: Btrieve 6.15
Backup: Backupexec
or        Arcsolo

The problem is, that the files in question are large (80 ... 150 MB) and that the update takes to long time.
Further: there are several Files with corresponding
content, so that it may produce troubble, if one
update file 1 at time x and file 2 at time x+y, y>0; because
file 2 may be changed between x and x+y, so that the
files on the update-tape may be not consistent.

Up to now we claim a break for updating for about 90 Min.,
but this is too long.
0
Comment
Question by:nmm
  • 2
  • 2
5 Comments
 

Expert Comment

by:drodey
ID: 1593760
St. Bernard's Open File Manager for Novell allows you to access open files, from almost any backup software as well as from regular copy/del commands.
Maybe you test with an eval copy..
0
 

Expert Comment

by:drodey
ID: 1593761
.
0
 
LVL 3

Expert Comment

by:brosenb0
ID: 1593762
Hi Nmm, Here's the answer as promised.

Btrieve 6.10 and greater supports what is known as continuous operations mode.  When a Btrieve file is placed into this mode, a delta file is created with the same file name as the original, however, the extension is .^^^ .  All writes to the file are now written to the delta file, with the original file frozen for the duration of the backup.  When the backup is complete and continuous operations mode has completed, all changes within the delta files are merged into the originals and the delta files are deleted.  By placing all related files within a database into a backup group, they can all be placed into continuous operations mode at the same time, effectively freezing the database for a backup snapshot that ensures referential integrity, whilst not restricting your users.

Ways to place files into continuous operations mode: -

1) The Btrieve supplied file manager, BUtil.Nlm can place files into continuous operations mode with the -STARTBU command.  You can pass a command line parameter to BUtil that specifies a text file containing a list of all Btrieve files within the backup group.  To end continuous operations mode, use the -ENDBU command.  These can be run by ARCserve pre & post job scripts or they could be run at a set time by Chron.Nlm from Novell.  Check out the BUtil section in your Btrieve 6.15 user's manual.  Online info can be found at www.pervasive-sw.com.

2) Cheyenne (CA) have a DBAgent for Btrieve on a NetWare server, that works with ARCserve 4 or greater.  Not sure if it works with ARCsolo, you will have to check with Cheyenne.  Using a Cheyenne supplied configuration utility, you create a configuration file containing the name of a file group and the list of files belonging to the group.  ARCserve contacts the agent prior to the backup and the agent instructs Btrieve to start continous operations mode.  A similar process occurs after all files in the group have been backed up to end continuous operations mode.  More info at www.cheyenne.com.


Caveat empor: -

1) You cannot have multiple files that have the same name and different extensions, eg. user.dat and user.hst.  This will cause a problem as Btrieve will place user.dat into continuous ops mode and then fail when it trys to do user.hst as user.^^^ already exists.

2) Btrieve must be manually told which files to place into continuous operations mode, you cannot specify wild cards.  If your application dynamically creates new Btrieve files then the above methods may not be suitable for you.  I have seen accounting applications that create a new file every time a new fund is created.  If this is the case with your app then I would suggest using the Cheyenne backup agent for open files or OFA.  This uses different methods to achieve a similar result and is not quite as clean as the native Btrieve agent.

3) Don't try to place more than around 1000 files into a group or your server will Abend.



Have fun.
0
 

Author Comment

by:nmm
ID: 1593763
because the answer from brosenb0 is much more usefull
0
 
LVL 3

Accepted Solution

by:
brosenb0 earned 100 total points
ID: 1593764
Nmm,

Is that what you where after?
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Assigning Admin Rights to Volume 4 594
Fingerprint reader - Novell & Windows 6 1,121
eDirectory difference between LDAP and NMAS 3 1,139
netware 5.1 license keys 15 1,507
In threads here at EE, each comment has a unique Identifier (ID). It is easy to get the full path for an ID via the right-click context menu. However, we often want to post a short link within a thread rather than the full link. This article shows a…
Ransomware is a malware that is again in the list of security  concerns. Not only for companies, but also for Government security and  even at personal use. IT departments should be aware and have the right  knowledge to how to fight it.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question