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.
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.