Subject Re: gbak takes days to restore large db?
Author dbambo2000
Sorry if I wasn't clear. I did zip the file at the remote server, ftp
it to the local system, unzip it, and then attempted to restore by
creating a copy of the db from the backup file on my local system.

So it is all happening locally.

Thanks for the input though!

--- In firebird-support@yahoogroups.com, "Sysdev/Paulo Botelho"
<sysdev@d...> wrote:
> 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@p...>
> 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
> >
> >
> >
> >
> >
> >
> >