Hello, Aage!

Friday, April 13, 2012, 11:55:38 PM, you wrote:


AJ>> gbak -se service_mgr
AJ>> -fix_fss_metadata ISO8859_1
AJ>> -fix_fss_data ISO8859_1
AJ>> -rep -v -z
AJ>> -user SYSDBA -password masterkey
AJ>> E:\...\...\sl1b3_20120412.fbk15 SL1
AJ>> ==================================
AJ>> Previous restores have never failed.

DK>> mmm, you did this command SEVERAL TIMES???

AJ> Yes, I've do this quite often.

if you run same command line for the same DB,
i.e. backup/restore, backup/restore, etc,
than you killed metadata in it.

Options -fix must be specified only ONE TIME,
when you restore your database at 2.5 from
previous versions backups, and moreover,
only if you have ERROR during restore without
-fix options.

AJ> Why wouldn't I use the same restore command each time I fetch a new backup?

because, as I said, -fix options are special options to fix incorrect
encoding of data and metadata, that could happen in previous FB
versions.

AJ> Any advice on improvements of the command is most welcome.

-rep is a nice option, that kills existing db.
I suggest not to get used to it, because sometimes bad things
can happen.
-c is the most correct option for restore.

--
Dmitry Kuzmenko, www.ib-aid.com