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
TIBCBackup & Restore have error while validate
-
- Posts: 7
- Joined: Wed 22 Jun 2016 04:06
Re: TIBCBackup & Restore have error while validate
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.
-
- Posts: 7
- Joined: Wed 22 Jun 2016 04:06
Re: TIBCBackup & Restore have error while validate
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
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
Re: TIBCBackup & Restore have error while validate
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.
We will consider the possibility to implement the mentioned functionality in one of the next builds of IBDAC.
-
- Posts: 7
- Joined: Wed 22 Jun 2016 04:06
Re: TIBCBackup & Restore have error while validate
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.
I execute gbak.exe -c -REP for restore the database temporary until TIBCRestore fix with allowing ROLE on connection to the service.
Re: TIBCBackup & Restore have error while validate
We have added ability to set ROLE when connecting to FB service in IBDAC 6.0.2, that is already available for download.