restore error -NODBTRIGGERS is allowed only on backup

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jet2050
Posts: 1
Joined: Thu 09 Apr 2020 21:47

restore error -NODBTRIGGERS is allowed only on backup

Post by jet2050 » Thu 09 Apr 2020 22:05

Hello

I'm trying to restore a firebird database using version 3.0.5 of FireBird with FireBird Embedded version 2.85 I have no problems.

the error is :

option -NODBTRIGGERS is allowed only on backup

The code I'm using is

Memo1.Clear;
Try
IBCRestore.UserName := 'SYSDBA';
IBCRestore.BackupFile.Text := 'myfile.fbk';
IBCRestore.Database.Text := 'mydatabase.fdb';
IBCRestore.Verbose := true;
IBCRestore.Active := true;
IBCRestore.ServiceStart;
while not IBCRestore.Eof do
Memo1.Lines.Add(IBCRestore.GetNextLine);

Memo1.Lines.Add('Done !!!!');
Finally
IBCRestore.Active := false;
End;

using Delphi XE with IBDAC version 6.1.7
also tested with Delphi Tokyo 10.2.3 with IBDAC version 6.3.11

Thanks for your help


Regards

Job Espejel

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: restore error -NODBTRIGGERS is allowed only on backup

Post by oleg0k » Mon 13 Apr 2020 08:29

Hello,
We've tested your code using version 6.3.11 and the latest version 7.1.3 of IBDAC, but couln't reproduce the issue in neither of them.
Please create a sample demonstrating the incorrect behavior and send it to us through the form on our website:
https://www.devart.com/company/contactform.html
We'll examine it and give you a complete answer.

wbr, Oleg
Devart Team

Post Reply