Subject RE: [firebird-support] Error 'reached end of file' during restore
Author Bob Murdoch

> -----Original Message-----
> From:
> Sent: Friday, February 16, 2007 9:02 AM
> At 12:38 AM 17/02/2007, you wrote:
> >
> >I'm curious what could have caused this problem? It looks to me
> >an out of space error, but that wasn't the case.
> It possibly was, though. If you don't have enough RAM available for

> building the indexes, the engine will use temporary files on disk
> the sorting. Check your TempDirectories setting in firebird.conf
> make sure you configure plenty of space for this purpose. (If you
> haven't configured any then Windows will just use any temp directory

> it knows e.g. your c:\temp directory might not have
> enough space available to it to accommodate your biggest index...)

I have one temp directory configured for a separate drive. Looking at
it now (while last nights restore is under way), there is 20GB free.
I do see 3.5GB of sort files in that folder though.

Is it possible that FB would need 20GB of temp space?

Bob M..