Restore Progress database

[triqt]

Hi,

The backup we have two files timedb.bk and timedb2.bk. To restore the database, we need to apply the command

prorest database-name timedb.bk

Do we need the run the command again for the timedb2.bk? Or it will automatic restore the timedb2.bk?

 

[Casper]

It will ask for the next volume during backup. You can also make a file with the 2 volume names in that and feed that to prorest.

What version of Progress and what OS and version are you using?

Casper.

 

[triqt]

Thanks

PROGRESS Version 9.1D as of Wed May 8 16:47:54 EDT 2002

[root@pacware2 dlc]# cat /etc/redhat-release
Red Hat Linux release 7.3 (Valhalla)

 

[TomBascom]

9.1D as of Wed May 8 16:47:54 EDT 2002

It is now June of 2009. 7 years on.

9.1E04 was the very last release of Progress version 9. There will never be another enhancement or bug fix.

The current release of Progress is OpenEdge 10.2. It contains several hundred significant enhancements, performance improvements and bug fixes. And it is actively supported.

You should upgrade.

To automatically restore when multiple backup files are needed first create a "reponse file" with extents 2+ listed. For example create "restore.list":

timedb2.bk
timedb3.bk
timedb4.bk
timedb5.bk

No blank lines and no leading spaces.

It is ok if there are more files listed than actually exist -- that makes it easy to be ready for future db expansion.

Restore with a command like this:

prorest timedb timedb.bk < restore.list

If you are restoring on top of an existing db add "y" as the first line of restore.list.

 

[triqt]

Thank you very much for your advise.