Subject gbak takes days to restore large db?
Author dbambo2000
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.