Thomas -

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas Steinmaurer
Sent: Friday, October 11, 2013 5:06 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Restore error during unique index creation

>> I have a 100GB database that I am trying to run a restore on after a
>> successful backup. This is on a new virtual Windows Server 2008 box
>> running FB 2.1.5 Classic 32-bit (due to some UDFs that have not been
>> ported).
>
>Might be temp file related. Temp files being tried to be created in a
>non-existing directory or exhausted disk space.
>
>Beside making sure that enough temp space is available, you might also
>consider:
>
>* Running th restore through the Services API/Manager
>* Provide a larger page cache upon restore, because especially the index
>creation step loves RAM. Don't forget to set the page buffers value back
>again at database-level after the restore via e.g. gstat. I've seen
>restore improvements of > 300% for largish indexes this way.

Are you talking about the -Buffers setting? Database has a page size of
16384, with buffers of 2048 because this is a classic server. What do you
think the buffers should be set to?

I was using service manager, but tried the direct connection on this machine
to see if that would speed up the restore (no such luck).

Thank you

Bob M..