Hi Louis,

> I recently began with a database cleanup procedure, I deleted about 4Gig of
> data out of a 9gig database.
>
> Before the script, it took about 1hour to backup database and 1.5hours to
> restore.
>
> Cleanup Script takes about 14min to complete.
>
> Backup after script takes 12hours to backup and 1.5 to restore.
>
> What can I do to speed this up? I cannot afford that my client go down for
> 13Hours +

You can run the backup when users a connected, so there is no need for
being in exlusive mode. But, if, in your case you want to use the
restored database instantly after the backup/restore cycle, and this
database should be replaced with backed up production database, then it
makes sense that no one is connected to the database.

Use gbak.exe with the -g option. This will suppress garbage collection
in the source database.



--
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