Subject RE: [firebird-support] Re: Firebird 1.0.3, How to drop file from multifile database?
Author Alan McDonald
> I ran the backup and it hickup'd again.
> Yesterday I created a multifile database, 41 files each file
> containing 40000 pages, each page 16K, use all space. I noticed that
> the last page was almost to 640MB so I made 10 more files this am
> through IB_SQL.exe using ALTER DATABASE AD FILE '.....42.gdb' LENGTH
> 40000; and then noticing that my backup last night didn't go off, I
> ran the backup which erased my good backup.
> I was wondering if I could tell the database to drop the files I
> added, since I haven't added anything new to the database and get on
> with things?
>
> Hugh

Something tells me you are tinking that you need to crete these files to
start a database off which intends to be very large...
you don't - just let the server grow the database when it needs it and then
when you max out the OS capability, you can then add additional files
Alan