I hope I am in the right place. I need to set the Progress database to backup automatically every night. I have never used Progress and would really like some help...I have NO idea how to achieve this at the minute. Any help is appreciated Thanks )
I hope I am in the right place.
I need to set the Progress database to backup automatically every night.
I have never used Progress and would really like some help...I have NO idea how to achieve this at the minute.
Any help is appreciated
You want to use the probkup command - this is the inbuilt Progress utility for backing up a Progress/OpenEdge database. If you want it done automatically on a set schedule, then you need to set up a cron script to do it..
thanks for the reply
I am going to assume you do this in the proenv part...use the probkup there.
What is generally in the cron script?
Well I have managed to backup the demo databases....
I need to backup the live database then create a .bat file on a scheduled task.
Can anyone explain why I am getting a "no server found for database..." error...I change the directory to the db directory then type
Probkup online databasename.db c:\db.pbk -com
And I get an error.....
The right forum would probably be the OpenEdge / RDBMS forum.
Do you have manuals? They are available on-line at PSDN. Look up probkup.
Online backup is for when a server is running. Offline backup is for when a server isn't running. Offline is a bit tidier and runs faster, but online allows people to continue working after the initial snapshot of the BI is made. When you restore an online backup, the database will need to go through crash recovery when first started. If you do online, you want to time it so that there is a clear time which the backup relates to in work flow. This will correspond to the start of the backup. If you use AI, which you should, then that is less important.
I just need to create a .bat file now and learn more about progress.
The online isn't working just now but users are logged in during the day so it maybe something to do with that.
Something like in a .bat file
%DLC%\bin\probkup online c:\data\mydatabase c:\backups\copyofmydatabase
If doing an ONLINE backup
%DLC%\bin\probkup c:\data\mydatabase c:\backups\copyofmydatabase
If doing an OFFLINE backup
Depending on your version of Progress this should just do it as one "probkup" file. Older versions used to have limits on size so you would end up with multiple 2GB files.
As someone mentioned when you do the ONLINE mode, transactions in the database are halted while a copy of the Before Image (roll back logs) are taken and then for a period
of time while the backup is running the system will be slower.
Hope this helps.
In the database log (which is a text file) e.g. mydatabase.lg there will be entries to say that a probkup had been taken.