Problems with TIBCRestoreService database 2.0 to 2.5

cdac901 · Post by **cdac901** » Wed 22 Dec 2010 01:59

I'm trying to make a recovery from a database of 2.0 to 2.5 with TIBCRestoreService generating the error:
gbak: Restoring DATA_ASSENTAMENT_TMP_S stored procedure
gbak: ERROR: Malformed string
gbak: Invalid metadata detected. Use-FIX_FSS_METADATA option.
gbak: Exiting Before completion due to errors

We managed to solve cmd.exe running this command:
gbak-c-v-t-rep Database.fbk Database.ib-user SYSDBA-password masterkey
-FIX_FSS_D ISO8859_1 ISO8859_1-FIX_FSS_M

It is possible a recovery of 2.0 to 2.5 by TIBCRestoreService a database with these characteristics?

Note: Sorry for my English.

AndreyZ · Post by **AndreyZ** » Thu 23 Dec 2010 13:52

Hello,

Please specify the exact errors that occur when you are trying to restore database using the TIBCRestoreService component (not gbak).
You can backup your database that works under Firebird 2.0 using this code:

Code: Select all

  IBCBackupService.Database := 'path to database';
  IBCBackupService.BackupFile.Add('backup filename');
  IBCBackupService.Attach;
  IBCBackupService.ServiceStart;

and restore the database under Firebird 2.5 from the backup file using this code:

Code: Select all

  IBCRestoreService.Database.Add('path to database');
  IBCRestoreService.BackupFile.Add('backup filename');
  IBCRestoreService.Attach;
  IBCRestoreService.ServiceStart;

upscene · Post by **upscene** » Wed 29 Dec 2010 08:01

AndreyZ wrote:Hello,

Please specify the exact errors that occur when you are trying to restore database using the TIBCRestoreService component (not gbak).
You can backup your database that works under Firebird 2.0 using this code:
Code: Select all
  IBCBackupService.Database := 'path to database';
  IBCBackupService.BackupFile.Add('backup filename');
  IBCBackupService.Attach;
  IBCBackupService.ServiceStart;
and restore the database under Firebird 2.5 from the backup file using this code:
Code: Select all
  IBCRestoreService.Database.Add('path to database');
  IBCRestoreService.BackupFile.Add('backup filename');
  IBCRestoreService.Attach;
  IBCRestoreService.ServiceStart;

Does this mean the Restore Services always adds that parameter?

AndreyZ · Post by **AndreyZ** » Wed 29 Dec 2010 09:33

FIX_FSS_M is a gbak's parameter. The TIBCRestoreService component doesn't use gbak tool for restoring.

upscene · Post by **upscene** » Wed 29 Dec 2010 09:38

I know, but is there some service equivalent or doesn't it require such?

AndreyZ · Post by **AndreyZ** » Wed 29 Dec 2010 11:10

The TIBCRestoreService component doesn't require such parameter.

vldg · Post by **vldg** » Wed 29 Dec 2010 14:37

AndreyZ wrote:The TIBCRestoreService component doesn't require such parameter.

This is totaly false !

http://tracker.firebirdsql.org/browse/CORE-2439

Other component allready include this