Adam wrote:

> gbak -m to get the DDL, if you have another database with the correct
> structure that is not corrupt, then this is even better to use.
>
> Restore the metadata only backup as your clean datapump destination.
>
> Use some data pumping tool to copy the data. I have had success with
> IBDataPump (clevercomponents), I am sure there are others too. Do a
> test run on another machine to minimise downtime.

If you need to do it on a regular basic (or you need it on
Linux/FreeBSD), you can use FBCopy and put it in a batch file:

http://fbutils.sourceforge.net/fbcopy/

--
Milan Babuskov
http://www.flamerobin.org