What version of Progress created a backup? - Forum - OpenEdge RDBMS - Progress Community

What version of Progress created a backup?

 Forum

What version of Progress created a backup?

This question is not answered

If I have a file created by probkup -- how can I determine what version of Progress was used to create it?

The first portion of the file is fairly readable text which makes it easy to confirm that the file is indeed a backup -- but it descends into binary chaos shortly after that.

--
Tom Bascom
tom@wss.com

All Replies
  • I do not think Progress has a probe, like the one you are looking for.

    You can do prorest db bkp -list  

    with different versions of Prorgess that you have. The one that will work will be the one backup was made with.

    Dmitri Levin

    Alphabroder

  • Good question.  I don't have a good answer.

    But feel free to vote for my enhancement request.  :)

    https://community.progress.com/community_groups/products_enhancements/i/openedge_database_enhancements_-_tell_us_what_youd_like_to_see/get_dlc_version_info_from_a_backup_file

  • >>prorest db bkp -list

    Sorry, I was wrong.

    prorest -list will work with different version of backup. So it could not be indication of a version. I would vote for Rob's enhancement.

    Dmitri Levin

    Alphabroder

  • > The first portion of the file is fairly readable text which makes it easy to confirm that the file is indeed a backup -- but it descends into binary chaos shortly after that.

    The structure of backup headers in old Progress versions (from ftp.progress-tech.ru/.../probkupinfo.sh ):

    # Progress backup header:
    #
    # V8     V9     
    # Offset Offset Len  Description
    # ------ ------ ---  -----------
    #   0      0     80  Backup volume description
    #  80     80     80  Full path to the database
    # 160    160     80  Incremental backup description
    # 264    264      4  Date/Time of current backup
    # 268    268      4  Date/Time of previous full backup
    # 272    272      4  Date/Time of previous incr backup
    # 276    276      4  Incremental backup number
    # 280    280      4  Database high water (V8 only)
    # 284    284      4  Value 0
    # 288    288      4  BI blocksize
    # 293    293      1  Is online (1 - online, 0 - offline)
    # 296    296    4/8  Backup Volume Size (-vs) divided by blocking factor (-bf)
    # 300    304      4  Blocking factor (-bf)
    # 304    308      4  Backup volume number
    # 308    312      4  First backup block in volume: 1+VolSize*(BkupVolNumr-1)
    # 312    316      1  Is incremental (2 = Incremental)
    # 313    317 60/255  Database path
    # 376    620      4  \07 \07 \07 \07 
    # 380    624      4  Last transaction number
    # 384    628      4  Overlap factor (-io)
    # 391    635      1  Is compressed (-com)  (2 = Enable)
    # 392    636      2  Redundancy (-red)
    # 396    640      4  Backup header CRC
    # 400    644      2  Database blocksize

    Version of Progress is not there.

  • Tom, it’s worse than that.  You may be able to restore a v10 DB with v11 and that will work, but then the database will be unusable since it will be a v11 database in a v10 container.  I have done this (accidentally) and it was quite confusing.  

    I am using od to dump out the backup header on a test database and nothing is jumping out to me that looks like the dbversion.  If you wait a while, I’m sure George P has a tool or will create one shortly ;)

    Mike
    -- 
    Mike Furgal
    Director – Database and Pro2 Services
    PROGRESS Bravepoint
    678-225-6331 (office)
    617-803-2870 (cell)