Kbase P161899: How can I change the physical name of the database using probkup/prorest
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/8/2010 |
|
Status: Verified
GOAL:
How can I change the physical name of the database using probkup/prorest
GOAL:
Is it possible to change the physical name of the database using prorest?
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
You can use prorest to change the physical name of the database. Below is an example using the sports2000 database.
proenv>probkup sports2000 sports2000.bak
OpenEdge Release 10.1C01 as of Sat Jun 7 16:06:03 EDT 2008
1348 active blocks out of 1651 blocks in sports2000 will be dumped. (6686)
0 BI blocks will be dumped. (6688)
The blocksize is 4096. (6994)
Backup requires an estimated 5.3 MBytes of media. (9285)
Restore would require an estimated 1348 db blocks using 5.3 MBytes of media. (9
86)
Backed up 1348 db blocks in 00:00:00
Wrote a total of 40 backup blocks using 5.3 MBytes of media. (13625)
Backup complete. (3740)
proenv>prorest test sports2000.bak
OpenEdge Release 10.1C01 as of Sat Jun 7 16:06:03 EDT 2008
Start of extending target DB to needed size... (9432)
This is a full backup of C:\wrk101c\sports2000.db. (6759)
This backup was taken Mon Mar 15 12:03:32 2010. (6760)
The blocksize is 4096. (6994)
It will require a minimum of 1417 blocks to restore. (6763)
Start of restoring the target DB... (9433)
Read 1348 db blocks in 00:00:01
Please note, that in the above example, there is no test.st (structure file), so all the areas are restored into a single extent. If you have a very large database with areas more than 2 gigs, you would want to create a test.st file first with the necessary extents predefined.