I knew you would ask that. Yes, once every couple of months
or so I go the long way of cleaning and backing up using the utilities.
Never ever had a corruption and always make sure that some select
count(*) from call is made at reqular intervals to reuse deleted space.
After the long way backup and restore, the 200Mb database hardly
changes in size. Maybe it works so well this way, because this
database is rather small :)

Best Regards
Hans

--------------------------------------------------------------------
Helen Borrie wrote:

>
> At 09:48 PM 15-01-02 -0700, you wrote:
> >The fastest way I found and never failed this far for over
> >an year, is turn all FB server activities off (most drastically stop
> >services) and run 'command xcopy database.gdb databaseback.gdb' ,
> >DO NOT use 'command copy' that fails. Just wrote a small application
> >that does this automatically at a certain time and datetimestamps the
> >backup. All done in at most a minute. But maybe your application
> >doesn't allow this approach.
>
> Hans,
> All very well, but this style of backup copies the database "as is" and you don't get any cleanup of garbage, releasing of page space ex deletes, detection of corruption, etc. How do you arrange to do database housekeeping with this scheme?
>
> regards,
> Helen
>
> All for Open and Open for All
> Firebird Open SQL Database · http://firebirdsql.org
> _______________________________________________________
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/