Subject Re: [firebird-support] Database Size Limit
Author Helen Borrie
At 12:08 PM 2/10/2006, you wrote:
>Dear All,
>I'm using Ms Windows 2000 server and installed firebird 1.53 on it.
>I'd like to transfer my 10 Gb ms SQL database to firebird.
>I've read that there's database size limit (or maybe file size
>limitation) on windows 2000 server.

There is no known "database size limit" per se. 10 Gb is "diddly"
compared to the size of many Firebird databases running out there.

However, your filesystem will determine both the maximum size of
database you can have and whether you need to work with multiple
files for your database. If your database file is on a NTFS
partition that was created by Windows 2000, the file size is limited
only by the space available on the partition.

>Do I need to create secondary file (or more) to handle this database ?

See above. You *can*, of course, make your database multi-file even
if you don't need to. You might wish to do this if you are stuck
with a hard disk that someone already partitioned into sizes smaller
than you need for the database and the extra disk space used by other
things (Firebird temporary sort space, virtual system memory and so
on). But, provided you have a full-blooded NTFS partition with
adequate free space, say 150% of the size of your freshly-restored
database, it's up to you how you manage potential growth.

>Or this secondary will be created automatically by firebird ?

No, secondary files are never created automatically. Firebird is
very conservative about the space it takes...however, you can use
ALTER DATABASE to append one or more secondary files whenever you
like and Fb will *use* them automatically if it gets to the point
where the primary file is nearing "full". The empty files don't use
much space.