Re: data pump or back up /restore

Article View: borland.public.interbase.opensource

Article #104

Back to borland.public.interbase.opensource Previous Next

#104

From: Craig Stuntz TeamB
Date: Thu, 28 Jul 2005 16:18

17 lines
1781 bytes

Bill Todd wrote:

> Backup and restore removes all unused space and makes the database
> file as small as possible.

	By default restoring a DB pads it with 25% extra space to help
performance after restoring. If you intend to set the DB read only, you
can use the "use all space" option when restoring to tell IB not to pad
the DB with blank space.

	Don't use this option with a read-write DB as it hurts performance.

-- 
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
How to ask questions the smart way:
  http://www.catb.org/~esr/faqs/smart-questions.html

Technical Details

Message-ID: <42e9054d$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!feeder2.on.meganewsservers.com!meganewsservers.com!textfeed1.on.meganewsservers.com!38.119.100.83.MISMATCH!news-out.nntp.be!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

References: <42e8e35c@newsgroups.borland.com> <42e900ac$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 106772,bc99fe6b8da79b64
X-Google-Attributes: gid106772,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Craig Stuntz [TeamB]" <craig_stuntz@nospam.please [a.k.a. acm.org]>
Subject: Re: data pump or back up /restore
Newsgroups: borland.public.interbase.opensource
References: <42e8e35c@newsgroups.borland.com> <42e900ac$1@newsgroups.borland.com>
Organization: Vertex Systems Corporation
User-Agent: XanaNews/1.17.5.7
X-Face: "huzh55Xi]!ZNni78>a*5+).`SK?<^q2MlHk-C]Z2M9T@\J5ZCB$95Ey+s"XQuhGFA[eutZ:0^AV!Q;t>gE`1-=8d;HZ6~*o1dH<X9\b$!|(}+I'!Xq)@3Op}%0ArW&nf'Qh*EwR
NNTP-Posting-Host: 24.106.104.204
Message-ID: <42e9054d$1@newsgroups.borland.com>
Date: 28 Jul 2005 09:18:21 -0700
X-Trace: newsgroups.borland.com 1122567501 24.106.104.204 (28 Jul 2005 09:18:21 -0700)
Lines: 17
X-Authenticated-User: cstuntz
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!feeder2.on.meganewsservers.com!meganewsservers.com!textfeed1.on.meganewsservers.com!38.119.100.83.MISMATCH!news-out.nntp.be!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Reply to Parent Message