Subject Re: "File Size Limit Exceeded" error message
Author ahaines_1
> >gbak -B -V -IG -L {source} {dest}
>
> That doesn't look like the exact command.
>
> What kind of partition are you writing to? If it is FAT32, you have
> a 2 Gb file size limit. That what it looks like here - you need to
> make multi-file backups. And note that you have to provide a full
> filepath as the argument to the -L switch.
>
/opt/interbase/bin/gbak -B -V -IG -L /var/interbase/moving.gdb
/var/interbase/moving.gbk

ext2 on linux (also with a 2GB limit).

I only started to look at the system since the users were being
disconnected when they used a specific table.
The database was setup to use multiple files starting at page 251278.
It would appear that page 251278 is in the main file rather than the
second file.
The file size is at 1936 MB (could be 2GB on disk though).

GBAK will start processing the file.
It gets to ~70% and then reports the error (on the same table the
users get kicked off on).

> Ivan Prenosil has a free tool (GLINK) to fix up the headers of a
> multi-file database when you move it, see
> http://www.volny.cz/iprenosil/interbase/ip_ib_download.htm

I'm trying this next.


The people from IBSurgeon suggested installing firebird 1.03 and try
the backup/restore.