Subject Re: [firebird-support] Re: sweep taking a long time
Author Nando Dessena

S> And what happens to the OLD database, if I let FB to do the garbage
S> collection?

it will be garbage-collected as a result of gbak visiting all records in
the database. This has a good effect on performance since it frees
pages for reuse and reduces the number of record back-versions.

S> Because I had a corrupt database, which I could not back up. (it stopped
S> backup with error messages). Then I instinctly turned off garbage
S> collection, and FB did a corerct backup, which I can the restore. The DB
S> have been working correctly since then.

I am not an expert in this area, and anyway without seeing what error
messages you got it is difficult to guess.

Nando Dessena
I support Firebird, I am a Firebird Foundation member!
Join today at