Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Backing up open Btrieve-Files

Posted on 1998-10-16
5
Medium Priority
?
538 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 300 total points
ID: 1593764
Nmm,

Is that what you where after?
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

WooCommerce is becoming the most powerful e-commerce plugin for Wordpress. And why not. The platform comprises of numerous core plugins that may come in handy, powerful options to make your website development task much easier.
Here in this article, you will get a step by step guidance on how to restore an Exchange database to a recovery database. Get a brief on Recovery Database and how it can be used to restore Exchange database in this section!
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

604 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