Additional db Files Question

Article View: borland.public.interbase.opensource

Article #5511

Back to borland.public.interbase.opensource Previous Next

#5511

From: Lou Feliz
Date: Mon, 19 Mar 2001 23:49

19 lines
1645 bytes

I am rolling out a small data warehouse application and want to plan for
growth beyond the 2GB range. The max size of the DB will be in the 6 to
10GB range.  I have created the following DB with the statements below
and just want clarification as the documentation helped, but I am still
a bit confused :


CREATE DATABASE "/usr/ibdata/dw.gdb" length 50000
FILE "ds.gd1" LENGTH 50000 PAGES
FILE "dw.gd2" LENGTH 50000 PAGES
FILE "dw.gd3" LENGTH 50000 PAGES;

When backing up the file with GBAK, will it back all files up (assuming
they contain data)?

When restoring with gBak, will it re-create the multiple files or just
the ones that contained data at the time of backup?

Thanks.

Technical Details

Message-ID: <3AB69AEF.6FF559F0@krmrisk.com>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!news-out.usenetserver.com!news-out-sjo.usenetserver.com!news.tele.dk!194.42.224.136!diablo.netcom.net.uk!netcom.net.uk!btnet-peer!btnet!newsfeed.bt.es!195.5.65.34.MISMATCH!caladan.arrakis.es!dnews!12.36.127.97

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 106772,aa46ef202066342e,start
X-Google-Attributes: gid106772,public
X-Google-ArrivalTime: 2001-03-19 16:24:11 PST
Message-ID: <3AB69AEF.6FF559F0@krmrisk.com>
Date: Mon, 19 Mar 2001 15:49:03 -0800
From: Lou Feliz <lfeliz@krmrisk.com>
Reply-To: lfeliz_at_krmrisk_dot_com
X-Mailer: Mozilla 4.61 [en] (Win98; U)
X-Accept-Language: en,pdf
MIME-Version: 1.0
Newsgroups: borland.public.interbase.opensource
Subject: Additional db Files Question
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 12.36.127.97
X-Trace: 19 Mar 2001 15:55:24 -0800, 12.36.127.97
Lines: 19
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!news-out.usenetserver.com!news-out-sjo.usenetserver.com!news.tele.dk!194.42.224.136!diablo.netcom.net.uk!netcom.net.uk!btnet-peer!btnet!newsfeed.bt.es!195.5.65.34.MISMATCH!caladan.arrakis.es!dnews!12.36.127.97