Devart Forums

I check validate "my database" have no error or warning, but every times I backup and then I restore "my database", I check validate database have some errors like this picture.



I set option on TIBCBackup like this.



Please tell me how to make restore database from backup database and have no page error / page warning.

Thanks
Regards

In order to get a detailed answer, please compose a small sample demonstrating the described behavior and send it to viktorv*devart*com, including the used database file. In addition, please specify the exact Firebird version.

I'm using firebird 3.0.

I found this problem solved yesterday, it caused TIBCRestore Options Set [roReplace, roCreateNewDB, roUseAllSpace] and I change into [roReplace, roCreateNewDB] the problem is solved

I have another problem when using TIBCRestore database into the Server LAN / Public, "no permission to Create database"

When I execute using gbak.exe and restore my database, it works correctly with ROLE "RDB$ADMIN"

I set ROLE "RDB$ADMIN" on IBCRestore.Params.Add(format('role ''%s''',['RDB$ADMIN']));
On component TIBCConnection it's work, but when I using TIBCRestore, it didn't work and result the error same like when I didn't using ROLE "no permission to Create database"

My question is how to set ROLE on IBCRestore?
Thanks

Currently, IBDAC doesn't allow to specify role on connection to the service.
We will consider the possibility to implement the mentioned functionality in one of the next builds of IBDAC.

Thanks for the answer, hope it will fix on next version,
I execute gbak.exe -c -REP for restore the database temporary until TIBCRestore fix with allowing ROLE on connection to the service.

We have added ability to set ROLE when connecting to FB service in IBDAC 6.0.2, that is already available for download.