ahaines_1 wrote:

> Thank you Steve and Helen.
>
> I am finally able to backup and restore the database.
>
> I am curious about the cause since it did use the secondary file before.
>
> I am now using a page limit of 131072 at 8192 bytes for a 1GB file size.
> This should give me some "buffer" space should the engine need to use it.
>
> Copying all 3 files from the linux server to my backup server (running
> windows), using the GLINK program, then running gfix seems to have
> worked. Of course, gfix reported a few errors (where IBSurgeon did
> not report any).

I'm not sure why it didn't use the other files if they were set up
correctly. We use ext2 and ext3 here and our parameters for our
databases are page size=8192 and page limit=255998. One of these
databases is up to 50 files long now and we haven't had a problem (yet
-- knock on wood).

-steve