Subject | Re: gbak with forced writes off |
---|---|
Author | diegoph79 |
Post date | 2010-02-22T13:14:15Z |
yes
delete from tb_movimento_estoque me where me.dt_movimento_estoque < '11/01/2009';
commit work;
delete from tb_ecf_venda where dt_venda < '11/01/2009';
commit work;
delete from tb_movimento_estoque me where me.dt_movimento_estoque < '11/01/2009';
commit work;
delete from tb_ecf_venda where dt_venda < '11/01/2009';
commit work;
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:
>
> Hi,
>
> > I made a deletion of many records.
> > To the process run faster I disabled the forced writes.
> > After this I run a backup restore with the options:
> > backup: gbak -g -b -z -l -v
> > restore: gbak -g -c -z -v
> > When I checked the new database restored, the deleteds records appeared again.
> >
> > OS - linux
> > Firebird - 2.1.3 classic
> >
> > There is something wrong with my process? maybe the switches of gbak
>
> Did you commit the delete operation?
>
>
>
> --
> Best Regards,
> Thomas Steinmaurer
> LogManager Series - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database, MS SQL Server and
> NexusDB V2
> Upscene Productions
> http://www.upscene.com
> My blog:
> http://blog.upscene.com/thomas/
>