INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Backing up Pervasive SQL Databases

Backing up Pervasive SQL Databases

(OP)
Hello all, I tried searching around on this forum and didnt find anything that helped with my following questions.....

We are running PSQL V11 SP2 on a MS 08 server. We have a couple of databases that are accessed constantly every day and at every hour as we have a very strong internet presence. This means that there will be files open for days/months at a time. Also, from what I gather, even when those files are closed and have new data stored on them, they will not necessarily change the modified date that you can see via Windows Explorer.

The above info is important when trying to do backups. We had Carbonite doing a full backup every week and daily differentials but now we have a Barracuda Backup 490 that takes a full snapshot the very first backup and essentially does differentials forever after that. Both Carbonite and Barracuda call VSS to enable the VSS writers to warn the prospective programs a backup and snapshot will be taken soon to allow for a correct backup. Unfortunately, neither program actually call the correct VSS writer for PSQL so that call goes ignored by both backup solutions. This would make either backup solution copy over just whatever data it feels has been changed but on a file level and not a database level. What I mean by that is that if a certain file is being written to at that exact moment a backup of that file tries to take place, it could lead to corruption. That is why the PSQL VSS writer was created. I have Barracuda trying to make me a special installer that includes that VSS writer but if they cannot or wont, I was wanting to know how you guys do your backups of PSQL databases? How do you do them on the fly when the database is being used and do you only do full backups or can you do differentials?

I stumbled upon PSQL Backup Agent but Im not sure on it just yet. It is offered by the company that now owns Pervasive.

Learning - A never ending quest for knowledge usually attained by being thrown in a situation and told to fix it NOW.

RE: Backing up Pervasive SQL Databases

Actually, Backup Agent was originally created by Pervasive but now both it and the PSQL engine are owned by Actian.
Backup Agent was created to add an easy to use interface to the Pervasive Continuous Operations functions.
The Continuous Operations functions are designed to backup files that are always open. When ContOps is turned on for a file, the base file (ex file.btr) is available for backup. A delta file (file.^^^) is created and changes are written to that file until ContOps is disabled.

Mirtheil
http://www.mirtheil.com

RE: Backing up Pervasive SQL Databases

(OP)
Yea, that confirms the reading I was doing on the Backup Agent. What is standard practice for backing up Pervasive DBs? Is it just doing a nightly full backup? Is there a way to force a differential? Is the only real way to back it up to have either its VSS writer or Backup Agent initiate the ContOps mode? The meat of our DB is in .btr files.

Learning - A never ending quest for knowledge usually attained by being thrown in a situation and told to fix it NOW.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close