Subject RE: [firebird-support] Failed restore
Author Bob Murdoch
> > -----Original Message-----
> > From: firebird-support@yahoogroups.com
> > [mailto:firebird-support@yahoogroups.com] On Behalf Of Vlad Horsun
> > Sent: Wednesday, June 06, 2007 10:05 AM
> >
> > May one of the tables reach limit ~36GB on pre-ODS 11 ?
> >
> > You can run gstat -t TABLE to calculate size of biggest TABLE
> > in your db
>
> The data is evenly split over a number of larger tables, so I
> don't think this is the problem. I'm running it now just to see.
>
> > May i ask you to try FB 2.0 (or 2.1 as it must be faster)
> > to restore this backup ?

I'm now thinking that it may have to do with Windows file compression. I try to keep seven days of restored databases available, and had set the folders to Compressed. Before installing FB2, I tried turning off compression on these folders, and have had two successful restores in a row.

I have looked for information on the max size of a compressed file but have not found anything. The other issue that made this less attractive as a possible cause is that the restore would work successfully most of the time. Perhaps I have just now hit the limit...

thanks,

Bob M..