Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backing up Pervasive SQL Databases

Status
Not open for further replies.

DrB0b

IS-IT--Management
May 19, 2011
1,425
US
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.
 
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top