RE: [firebird-support] Gbaked and restored database larger than the original?

2015-07-08 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
Take a look here: http://www.firebirdfaq.org/faq361/ I'd add that restore also has a -use_all_space option. If you don't specify this, then pages are filled to approximately 80% (80% is preferable over 100% unless it is a read-only database). See http://www.firebirdsql.org/manual/gbak-cmdline.h

RE: [firebird-support] Gbaked and restored database larger than the original?

2015-07-08 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On Wed, 8 Jul 2015 12:14:13 +, "Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]" wrote: > Take a look here: http://www.firebirdfaq.org/faq361/ > > I'd add that restore also has a -use_all_space option. If you don't > specify this, then pages are filled to approx

Re: [firebird-support] Gbaked and restored database larger than the original?

2015-07-08 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
On 2015-07-08 o 14:14, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] wrote: > Take a look here: http://www.firebirdfaq.org/faq361/ Yes, I've come across this on another occasion, but it doesn't seem to apply to my case (I didn't switch to a different version of F

Re: [firebird-support] Gbaked and restored database larger than the original?

2015-07-08 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
W dniu 2015-07-08 o 14:18, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Another reason could be restoring with a different page size than the > original database. Both databases have 8k pages. Tomasz -- __--==--__ __--== Tomasz Tyrakowski=

Re: [firebird-support] Gbaked and restored database larger than the original?

2015-07-08 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
> On Jul 8, 2015, at 8:14 AM, Svein Erling Tysvær > svein.erling.tysv...@kreftregisteret.no [firebird-support] > wrote: > > Take a look here: http://www.firebirdfaq.org/faq361/ > > I'd add that restore also has a -use_all_space option. If you don't specify > this, then pages are filled to ap