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

x
?
Solved

Arcserve's Brtrieve 7.0 DB is corrupted - How to repair?

Posted on 2003-12-04
6
Medium Priority
?
4,605 Views
Last Modified: 2013-12-25
This may or may not require some familiarity with ARCSERVE. I am using ARCSERVEIT 6.6 for backup on a Netware 5 server. It uses btrieve 7.0 to maintain its DB of backup jobs. I'm getting an error message 4205 in ARCSERVE that tells me the DB will not open due to integrity check failure. The KB at Computer Associates describes the process to recover the DB, but simply says, "Submit Recover ARCserve Database job from console". Unfortunately, I cannot find any reference in their KB as to how you do that.

In older versions, I used a BUTIL NLM that would repair or recover Btrieve 6.x files, but apparently that utility doesn't work with ver 7.  If you know the correct procedure to repair a corrupted ver 7 file, I would greatly appreciate your help.

Thanks in advance.

0
Comment
Question by:jaytucker1
[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
  • 3
  • 3
6 Comments
 
LVL 18

Expert Comment

by:mirtheil
ID: 9877020
What error do you get when you run BUTIL against the 7.x files?  BUTIL should still work.  If that doesn't work, you could use BUTIL at the client to do the same thing.
0
 

Author Comment

by:jaytucker1
ID: 9879764
I had not tried BUTIL, as the Arcserve KB docs said it wouldn't work.  When I got your reply, I ran it and got BUTIL-100: The client table is full. Try increasing the number of Active Clients in the MKDE system resource setting.
So I increased the value in BTI.CFG and now when I run it I get this error:
BUTIL-14: The file that caused the error is SYS:TEMP
BUTIL-100: An error occurred during the access of the sequential file.
The command I'm running is:
BUTIL -RECOVER SYS:ARCSERVE\DATABASE\ASJOB.DB TEMP
This should create a recovered file called TEMP at the root of SYS:, which I can then load with BUTIL into an empty database.

I tried another DB file to see what would happen and the message was the same.  These files are only 144K and 408K, and SYS has over 1GB of free space, so space shouldn't be an issue.  Any ideas?
0
 
LVL 18

Expert Comment

by:mirtheil
ID: 9880015
What happens if you actually specify SYS: and give the file an extension in the BUTIL command like:
BUTIL -RECOVER SYS:ARCSERVE\DATABASE\ASJOB.DB SYS:TEMP.UNF

It could be that the engine/OS is confused if there is a TEMP directory as well as trying to create a file by that name.

0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 18

Accepted Solution

by:
mirtheil earned 1000 total points
ID: 9880028
I just tried it here on Windows and got the same error if I specified only TEMP.  If I added an extension, it worked just fine.
0
 

Author Comment

by:jaytucker1
ID: 9883673
I'll bet you're right.  I'll give it a shot and let you know.
0
 

Author Comment

by:jaytucker1
ID: 9884187
Mirtheil, you were right, and I should have recognized the filename confusion.  Most importantly, you knew that BUTIL would work, contrary to what Computer Associates was saying.  I love those tech support articles that steer you in the wrong direction!  Many thanks!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
What we learned in Webroot's webinar on multi-vector protection.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
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