> There is 77GB free out of 148GB at the minute and it has restored 9GB so > far, final size ~33GB so on the surface looks adequate unless very large > temp files are created when the indexes are reactivated?
Yes. This may happen, depending on the index size. Are you sure that temp space is actually pointing to the disk with 77G free space? * What is the value for the TEMP/TMP environment variable (in case you are on Windows)? * Any manual changes for TempDirectories in firebird.conf? -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
