What version of Progress created a backup?

Posted by ChUIMonster on 07-Apr-2017 15:28

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.

All Replies

Posted by Dmitri Levin on 07-Apr-2017 15:35

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.

Posted by Rob Fitzpatrick on 07-Apr-2017 15:39
Posted by Dmitri Levin on 07-Apr-2017 15:46

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

Posted by George Potemkin on 08-Apr-2017 00:50

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

Posted by mfurgal on 11-Apr-2017 21:30

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)


This thread is closed