restoring database

R

richieasir

Member
hi all,
Greetings from Richards.

I created a database with the size of 10 gb(just in test box for my practise) and i took a backup of it and stored in another location.
and i used to restore the same databse using prorest in someother location. but i can see a huge difference in size of database ie in extent size?
so wat i did is,i just restore the database where my backup is and i copied the .st file and pasted it in new location where i want the database and then i restored it.now i could get the database with same size of what i created before.
is prorest needs .st file of that particular DB to restore the same databse in some other location?
why such huge difference in sizes?
could u please say me why?
explain in detail please!!!!

regards
Richards.
 
You can use probkup & prorest to change the locations and size of extents.

Prorest will restore into whatever structure is described in any .st file with the right name that happens to be present. The .st file only needs to have the same areas described as the source db had. The extent locations and sizes can be different. They can do this because probkup and prorest know where the high water mark in each storage area is.

You can also save time restoring by doing a prostrct create using that .st file ahead of time.
 
You must log in or register to reply here.
Back
Top