Page 1 of 1
Problems with TIBCRestoreService database 2.0 to 2.5
Posted: Wed 22 Dec 2010 01:59
by cdac901
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.
Posted: Thu 23 Dec 2010 13:52
by AndreyZ
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;
Posted: Wed 29 Dec 2010 08:01
by upscene
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?
Posted: Wed 29 Dec 2010 09:33
by AndreyZ
FIX_FSS_M is a gbak's parameter. The TIBCRestoreService component doesn't use gbak tool for restoring.
Posted: Wed 29 Dec 2010 09:38
by upscene
I know, but is there some service equivalent or doesn't it require such?
Posted: Wed 29 Dec 2010 11:10
by AndreyZ
The TIBCRestoreService component doesn't require such parameter.
Posted: Wed 29 Dec 2010 14:37
by vldg
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
