Thomas - -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Steinmaurer Sent: Friday, October 11, 2013 5:06 PM To: [email protected] 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..
