You could also try deactivating the indices from the
table you had just deleted from before doing a backup.

You might have to re-activate the indices when you
restore them though.

--- Milan Babuskov <albis@...> wrote:

> fabiano_bonin wrote:
> > I had a table with 200.000 records.
> > I deleted 180.000 records from this table.
> >
> > Now i'm trying to backup my database and the gbak
> stop in this table
> > and never go away.
> >
> > Am i right? If yes, is there some workaround to
> avoid this delay?
>
> If you don't have many records left in the table,
> you can copy them to
> some temporary table (insert into .. select from),
> drop the original
> table. Do backup/restore. Create the original table,
> copy data back, and
> drop the temporary.
>
> I sometimes do it like that.
>
> --
> Milan Babuskov
> http://fbexport.sourceforge.net
>
>
>

__________________________________
Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.
http://promo.yahoo.com/sbc/