RE: [firebird-support] TMP space required during restore

2012-01-26 Thread Rick Debay
Twice the size is an old and possibly still a good guess, I think. It all depends on the number and size of the indices. So to restore an 11GB database we should have 22GB available where TempDirectories points? Disclaimer: This message (including attachments) is confidential and may be

Re: [firebird-support] TMP space required during restore

2012-01-26 Thread Alexey Kovyazin
Rick, So to restore an 11GB database we should have 22GB available where TempDirectories points? No. Download our free tool DBInfo (http://ib-aid.com/products/firebird_interbase/monitoring/dbinfo) and open your database there. Look at Index Pages size. If you have the single table with the

Re: [firebird-support] TMP space required during restore

2012-01-24 Thread Thomas Steinmaurer
gbak: ERROR: I/O error for file /tmp/fb_sort__M9plMy gbak: ERROR: Error while trying to write to file gbak: ERROR: No space left on device We've started getting this error when restoring an 11GB database. How much space should we estimate for temp files? Twice the size is an old

Re: [firebird-support] TMP space required during restore

2012-01-24 Thread Ann Harrison
Rick Debay wrote: gbak: ERROR: I/O error for file /tmp/fb_sort__M9plMy gbak: ERROR:     Error while trying to write to file gbak: ERROR:     No space left on device We've started getting this error when restoring an 11GB database.  How much space should we estimate for temp files? More.