Subject Re: [firebird-support] Help ! Restore Database Problem
Author Helen Borrie
At 09:08 AM 15/04/2004 -0600, you wrote:
>Hello All,
>
>I have a small database that I am unable to restore. It seems to backup
>fine but when I attempt to restore I get this message:
>
>gbak.exe -r broker.gbk C:\broker_web\database\broker.gdb -user USER -pas
>PASSWORD
>gbak: ERROR: I/O error for file "C:\WINNT\SYSTEM32\FAX_PA~1"
>gbak: ERROR: Error while trying to open file
>gbak: ERROR: The system cannot find the file specified.
>
>I have a table named FAX_PARAMETERS but I am not sure why gbak is
>looking in another directory for this file. Is there any way I can
>remove this dependency? I am not really concerned about the restore I
>just need to make sure future backups do not have this problem.
>
>I am running Firebird 1.0.3, Pentium 4 - 2.6Ghz, Windows XP
>
>I can provide any additional information if necessary. Thanks in advance.

First, NEVER use gbak -r. Use gbak -c and restore using some other name.

Second, the file it can't find is not the database file, it's the backup
file. Provide the full path to the backup file and the error should go away.

/heLen