On 01/05/13 15:25, Nick Upson wrote:

> does this option just restore the data using 100% of each page and then the
> database works as normal, with 80% usage or does it restore the data to
> 100% and then force all subsequent use of the database to work at 100%
> usage as well. I can read the extract below either way.

The way I wrote it, and I can see your confusion, is that the restore
writes 100% of the space in each page and leaves no room to allow
updates in that same page.

The default (ie, if you leave this parameter off the command line) is to
leave 20% of each page for future updates.

I'll reword the manual. ASAP.

After the restore is completed, and as far as I am aware, the normal
80-20% usage continues on new pages.

HTH

Cheers,
Norm.

--
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767