> Kevin Hamilton wrote:
> > Ann W. Harrison wrote:
> >>
> >>Yes, the backup will have less impact without the -g switch, but if
> >>you have a time when there's less load, then do one backup then
> >>without the -g to reduce the overall load during busy times.
> >>
> >
> >
> > I'm assuming that should be:
> >
> > "If you have a time when there's less load, then do one backup then
> > WITH the -g to reduce the overall load during busy times."
> >
> >
> Sigh, the sense of the switch is backward. If you include -g, garbage
> collection does not happen. So, what I should have said is:
>
>
> Yes, the backup will have less impact WITH the -g switch, but if
> you have a time when there's less load, then do one backup then
> without the -g to reduce the overall load during busy times.
>
> Duh...
>
> Ann

I'm assuming now, you mean
"then do one backup, when the load is low, without the -g to improve overall
database health. (assuming you do not intend to restore from the backup at
this time)"
Alan