Maybe the problem is here :

"... from a remote Win2003 server to my local WinXP... "

How about the connection speed ? Can't you zip the backup file , tranfer it
to your local machine and start the restore locally ?

Paulo Botelho

----- Original Message -----
From: "dbambo2000" <gcampbel@...>
To: <firebird-support@yahoogroups.com>
Sent: Saturday, July 23, 2005 5:09 PM
Subject: [firebird-support] gbak takes days to restore large db?


> Hello,
> I am attempting to restore a 15GB database (containing 18 thousand
> tables) from a remote Win2003 server to my local WinXP Pro Pentium 4
> system with 768MB Ram. I began the restore about 20 hours ago and
> thus far it has restored about 5.7 gigabytes. At this rate it will
> take a few days to complete the restore. Is this normal? Can I do
> anything to speed things up?
>
> I understand that gbak creates indexes during the restore and that
> this contributes to the time required to complete the process.
>
> Also, while running the restore, I mistakenly connected to the
> database from IB Manager. I didn't open any tables or modify any
> data. I only made the connection to the db and then immediately
> closed the connection. Could doing so have corrupted the restore? If
> so, would it have said so via some error message immediately at the
> command line prompt where the gbak command was initialized? Nothing
> has changed at the command line prompt. The gbak command was not run
> with the verbose option enabled.
>
> Thanks for any help on this matter.
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>