Help Needed - How do you Backup a progress database? - Forum - Community Groups - Progress Community

Help Needed - How do you Backup a progress database?

 Forum

Help Needed - How do you Backup a progress database?

  • 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

    )

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

    Consulting in Model-Based Development, Transformation, and Object-Oriented Best Practice  http://www.cintegrity.com

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

    Consulting in Model-Based Development, Transformation, and Object-Oriented Best Practice  http://www.cintegrity.com

  • thanks

    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.

  • Hi


    Something like  in a  .bat file

    set  DLC=c:\dlc

    %DLC%\bin\probkup  online   c:\data\mydatabase    c:\backups\copyofmydatabase

    If doing an ONLINE backup

    set  DLC=c:\dlc

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

    Thanks

    Kevin