Subject Re: [firebird-support] FB Restore Error
Author Helen Borrie
At 07:02 PM 9/02/2006, you wrote:
>Hi,
>
>I have backup my DB in 2 files, muscopedia.311005.1 muscopedia.311005.2.
>Now, I am trying to restore them using:
>
>gbak -c -user mouse -password mouse muscopedia.311005.1
>muscopedia.311005.2 muscopedia.fdb 2g muscopedia.fb2 2g muscopedia.fd3
>
>But I get the following error, which I cannot understand...
>
>gbak: ERROR: size specification either missing or incorrect for file
>muscopedia.fdb
>gbak: Exiting before completion due to errors
>
>Can someone please enlighten me?

You need to specify the file sizes as the number of database
pages. You're not quoting a page_size parameter here for your
restore and you don't say what version of anything you are using, so
use isql's SHOW DATABASE command to find out the page size because
defaults vary among the versions.

Assuming you want to limit the file sizes to 2 Gb, divide
2,000,000,000 by the page size and use that number. I think you can
use 'K' and 'M' as shortcuts for thousands and millions respectively,
'g' looks doubtful here.

./heLen