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 <[email protected]> > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > 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 > > >
