Helen,

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> 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

like

> >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

for

> the sorting. Check your TempDirectories setting in firebird.conf

and

> 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 about....so 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..