marcoaureliocastro wrote:

>
> What happens when I delete a lot of records in a data base and try
> to make a backup of it?

When you delete a lot of records, the records are marked as deleted but
not removed until after your transaction and all other concurrent
transactions commit. If your goal is to quickly shrink the database by
doing a backup/restore, the -g switch is your friend.

Normally gbak, like any other application, removes unneeded old versions
of records from the data areas and from the indexes. If you don't care
about cleaning up the old copies, use the -g switch to tell gbak not to
do any cleanup.

Regards,


Ann