online backup do a proquiet or not?

Moussa

New Member
Hi, I am looking at someones progress backup scripts and see some odd things. Version running is 9.1d.

What I've learned is that later versions of progress can do an online backup without having to quiet the databases. And users won't notice anything.

This is how the backup is done now:

#beging backup script

Send message to all users that bu begins and they need to stop
proquiet /dir/db1 enable
proquiet /dir/db2 enable
proquiet /dir/db3 enable
proquiet /dir/db4 enable

probkup online /dir/db5 db5.bu

proquiet /dir/db5 enable

proquiet /dir/db1 disable
proquiet /dir/db2 disable
proquiet /dir/db3 disable
proquiet /dir/db4 disable

probkup online /dir/db2 db2.bu
probkup online /dir/db3 db3.bu
probkup online /dir/db4 db4.bu
probkup online /dir/db1 db1.bu
proquiet /dir/db5 disable
Send message to all users that they can resume
# end backup script


And I'am looking to change this to:

#begin
probkup online /dir/db5 db5.bu
probkup online /dir/db2 db2.bu
probkup online /dir/db3 db3.bu
probkup online /dir/db4 db4.bu
#end


Will this cause any issues? I'am suspecting the quiet is legacy from old progress versions and when upgrades went the bu scripts are left untouched.


Thanks in advance, moussa
 

TomBascom

Curmudgeon
Your new method is better.

The old code was never necessary and is decidedly odd. Online backup has never required a proquiet and there is no need for users to pause. There is some potential for a brief pause in transaction activity when the backup starts as the bi file is backed up but on modern hardware that pause is usually very brief -- it is unlikely to be noticed.
 
Top