Subject | Re: [firebird-support] Re: sweep taking a long time |
---|---|
Author | Alexandre Benson Smith |
Post date | 2005-11-08T23:12:45Z |
k_smith_000 wrote:
No !
When you backup your data, just the "good" data goes to the backup, no
garbage is stored in the backup, so it will not be restored.
A restored database was clean as it can be, no garbage, no unbalanced
indices, update statistics and so on.
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
>--- In firebird-support@yahoogroups.com, "Ann W. Harrison"Kevin,
><aharrison@i...> wrote:
>
>
>>k_smith_000 wrote:
>>
>>
>>>1.gbak -b -g
>>>2.gbak -r
>>>3.sweep
>>>
>>>
>>>
>>Don't bother sweeping a newly restored database. It's
>>already clean. And be careful of the -r switch, it
>>will overwrite an existing file.
>>
>>
>As far as I know gbak -g parameter stops garbage collection from
>running during backup, so even if I make restore after backup without
>garbage collection(gbak -b -g), I should perform sweep... (?)
>
>Kevin Smith
>
>
>
>
No !
When you backup your data, just the "good" data goes to the backup, no
garbage is stored in the backup, so it will not be restored.
A restored database was clean as it can be, no garbage, no unbalanced
indices, update statistics and so on.
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br