Hello,

> We have backed up our databases daily for two years using Firebird 2.52
> Superserver and its associated gbak. We now need to restore one of the
> databases and gbak fails to do the restore, giving the following error:
>

[snip gbak output]

> gbak: ERROR:action cancelled by trigger (3) to preserve data integrity
> gbak: ERROR: table/procedure has non-SQL security class defined
> gbak:Exiting before completion due to errors
>
>
> We have no procedures defined in or for our database. It appears gbak
> has restored the database except for something at the end. The database
> is working correctly every day. Is this copy of the database backup toast?
>
>
> Should we be using a different backup tool like nbackup? Can we use
> Interbase gbak to recreate the database?
>
>
> We are backing up our databases on Windows 7 using 2.52 Superserver.
> The databases are on a Linux Mint server.

I'm confused. The databases are hosted on Linux (InterBase or Firebird?)
but you are running a backup from Win7?

You asked something similar > 2 years ago:
http://comments.gmane.org/gmane.comp.db.firebird.user/7145


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

> However, when we are trying
> to do the restore, we are restoring it to a directory on Windows 7
> because we don't trust restoring it over the currently running
> database. So, the backup and restore are both on the same Windows 7
> computer using the same 2.52 Superserver.
>
>
> We need some data from the database from yesterday, so we just wanted to
> restore that long enough to pull the data. The table we want, ON_ORDER,
> appears to have been restored but we cannot open the restored database
> to access it.
>
>
> Help?
>
>
> ------------------------------------
> Posted by: Jack Mason <jackmason@...>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu. Try FAQ and other links from the left-side menu there.
>
> Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ------------------------------------
>
> Yahoo Groups Links
>
>
>