Subject | RE: [firebird-support] Re: GBAK Backup Size |
---|---|
Author | Andrew Stuart |
Post date | 2008-07-21T07:17:42Z |
We get a lot better Backup size using the Transportable option, I just
wanted to be sure I don't lose anything from running these types of
backup?
Non-transportable = 3.5GB backup
Transportable = 890MB Backup
Windows reported DB Size = 1.5GB
I'm 99.99% sure it'll be fine, but as its quite a drop in backup size...
heh
And as always, its always good to hear it from someone else too!
Cheers
Andrew
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: 17 July 2008 16:21
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: GBAK Backup Size
Jason Chapman wrote:
data in the backup is not compressed as it is when it's stored. A
database with lots of over sized fields and few indexes might be
bigger in a backup.
Regards
Ann
Head and Registered Office:
Call Assist Ltd,
Axis Court, North Station Road,
Colchester, Essex.
CO1 1UX
Telephone +44 (0)1206 771771
Fax +44 (0)1206 364268
Registered in England and Wales.
Registered Company Number 3668383
Authorised and regulated by the Financial Services Authority
Please Note : This electronic message contains information from Call Assist Ltd which may be privileged or confidential.
The information is intended for the use of the individual(s) named above. If you are not the intended recipient be aware
that any disclosure, copying, distribution or use of the contents of this information is prohibited.
If you are not the intended recipient please delete this email. If you have received this electronic
message in error, please notify us by telephone or email immediately.
Please consider the environment before printing this email.
[Non-text portions of this message have been removed]
wanted to be sure I don't lose anything from running these types of
backup?
Non-transportable = 3.5GB backup
Transportable = 890MB Backup
Windows reported DB Size = 1.5GB
I'm 99.99% sure it'll be fine, but as its quite a drop in backup size...
heh
And as always, its always good to hear it from someone else too!
Cheers
Andrew
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: 17 July 2008 16:21
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: GBAK Backup Size
Jason Chapman wrote:
>Usually, but not always. Unless my memory is worse than usual, the
> As a GBK is just meta data and then the data streamed, and a FDB has
> additional space requirements for indices and the fact that records
> don't 100% fill the page space, DB's are bigger than backups.
>
data in the backup is not compressed as it is when it's stored. A
database with lots of over sized fields and few indexes might be
bigger in a backup.
Regards
Ann
Head and Registered Office:
Call Assist Ltd,
Axis Court, North Station Road,
Colchester, Essex.
CO1 1UX
Telephone +44 (0)1206 771771
Fax +44 (0)1206 364268
Registered in England and Wales.
Registered Company Number 3668383
Authorised and regulated by the Financial Services Authority
Please Note : This electronic message contains information from Call Assist Ltd which may be privileged or confidential.
The information is intended for the use of the individual(s) named above. If you are not the intended recipient be aware
that any disclosure, copying, distribution or use of the contents of this information is prohibited.
If you are not the intended recipient please delete this email. If you have received this electronic
message in error, please notify us by telephone or email immediately.
Please consider the environment before printing this email.
[Non-text portions of this message have been removed]