Getting error during Restore: Error 9452

Reynold

Member
Hello All,

While doing a restore of Database backup to a new empty database using "prorest" command, I am getting the below error:
**************************************************
proenv>prorest D:\Progress\WRK\ttjob jobdb.bak
PROGRESS Version 9.1E as of Tue Oct 12 20:29:29 EDT 2004
Start of extending target DB to needed size...
SYSTEM ERROR: Attempted to exceed maximum size on file D:\pro91e\WRK\ttjob.d1. (94
52)

Unable to extend data files enough to proceed. (6743)
Restore failed. (1618)
!!! ERROR - Database restore utility FAILED !!! (8564)
*********************************************************

I did a List of the DB which I want to restore and it gives result as:

proenv>prorest D:\Progress\WRK\ttjob jobdb.bak -list
PROGRESS Version 9.1E as of Tue Oct 12 20:29:29 EDT 2004

Area Name: Schema Area
Size: 46413248, Records/Block: 64, Area Number: 6

Can anyone Help Please. It will be really urgent !!!

Thanks in advance
 

Casper

ProgressTalk.com Moderator
Staff member
ok all tables reside in the schema area. You possibly have a workgroup license and cant have biger files then 2GB or you just went out of disk space. Just make an st file named <databasename>.st and put enough extents of 2 GB in it so the all the data will fit there. (or use the original st file from the database where the backup was made from, change the path to reflect the new location of the database). Delete the new database and restore in the desired location, with the st file present in that location.
You could also to do a restore in an empty directory, prorest will create the database as needed).

HTH,
Casper.
 

Reynold

Member
Still I am facing the issue, I cleared the dist space and have a plenty of space now on disk.

One Thing I want to bring in notice is that The backup file (.bak) I have is of 4GB. So could you please help how can I create a new structure file so that I won't get the same error. I will really be thankful to you.

The system created automatically a structure file when I did prorest commnad and that contains:
***********************
# generated by PROREST on Mon Apr 18 13:01:56 2011
b .
d "Schema Area":6,64 .
***********************

So please help How can I create a new structure file and what I need to mention in that, so that I wont get the same error which I mentioned above.

Thanks in advance
 

Casper

ProgressTalk.com Moderator
Staff member
well make something like:
Code:
# generated by PROREST on Mon Apr 18 13:01:56 2011
b <databasename>.b1
d "Schema Area":6,64  <databasename>.d1 f 1024000
d "Schema Area":6,64  <databasename>.d2 f 1024000
d "Schema Area":6,64  <databasename>.d3 f 1024000
d "Schema Area":6,64  <databasename>.d4 f 1024000
d "Schema Area":6,64  <databasename>.d5
a <databasename>.a1
a <databasename>.a2
a <databasename>.a3
a <databasename>.a4

Regards,
Casper.
 
Top