Problem is we're a 24/7 company and it takes a while to scedule reboots of certain critical systems

any ideas what sort of performance issues with the GDB?

i did delete the exisiting backup and watched it backup again, still was 2gig more than current FDB
Also all the DB's on that server only make up 2.4GB, which is still a gig less than the main DB's FBU ;\

ill have to see if i can scedule a restart of the service or something, i dont quite know how to release all the handles? if thats just a case of no users being connected, we'd never have that situation occur in normal business use.

Cheers for pointers so far


________________________________

From: firebird-support@yahoogroups.com on behalf of Adam
Sent: Thu 17/07/2008 00:15
To: firebird-support@yahoogroups.com
Subject: [***SPAM*** Score/Req: 5.4/4.0] [firebird-support] Re: GBAK Backup Size



--- In firebird-support@yahoogroups.com <mailto:firebird-support%40yahoogroups.com> , "call.assist"
<Andrew.Stuart@...> wrote:

>
> Hi
>
> (prob doing something stupid here, but hey ho)
>
> I've a couple of different DB/Servers running gbak regulary
>
> I've noticed one has a GDB file size of 1.5gig, and GBK produced is ~
> 1.5GB

Don't use GDB file extension on Windows. Irrelevant to your problem
but will cause other performance issues.

>
> Another has a CABS FDB of 1.5Gig and produces a FBU of around 3.5GB
>
> both use exactly the same gbak command line , within reason.
>
> "D:\Program Files\Firebird_1_5\bin\gbak" -backup -user SYSDBA -
> password xxx -nt localhost:e:\Data\DB.fdb e:\Backup\DB.FBU
>
> any ideas?

In my experience, the backup file is always smaller than the database.
This makes sense, because the database file will contain deleted data
awaiting garbage collection as well as indices, whereas the backup
file only contains the index definition and obviously no deleted data.

Have you shutdown the Firebird service after making the backup?
Remember explorer doesn't always update the displayed file sizes in an
expected manner, so your database file may actually be larger that
1.5GB. You don't necessarily need to shut down the service, but
releasing all the handles to the gdb file will probably trigger it to
refresh the file size.

The only other flag I can see there it the non transportable backup,
meaning you won't be able to restore it on some non x86 architectures,
but I don't see how that would increase file size.

Adam




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.