The databases reside on a Linux Mint server, but we back them up to a Windows 7 system.   Both are running the same release of Firebird.  We use Linux as the server because Linux is far more reliable than Windows for everything, but it is the only Linux computer we use.  Everything else is Windows because of other software we run.  So, to back up the databases, we put the backups on a Windows 7 computer, blandly assuming it is just a file that can be restored by the same program that backed it up, gbak on Windows 7.

We had the same problem two years ago, and it never got resolved, it just disappeared, so we assumed we had done something wrong and were no longer doing whatever that was.

Jack

 

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
>
>
>

--
"Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other." -- John Adams, Oct. 11, 1798 "Where there is no vision, the people perish.." Prov 29:18