> The databases are backed up between midnight and 6 am when no one is > using them. However, the databases are still open in multiple > programs. The backup is: > > C:\"program files"\firebird\firebird_2_5\bin\gbak -b -v -user SYSDBA > -pas masterkey 192.168.1.252:/bfl/smtbdb/customer > C:\backups\Buford\Thursday\customer.bak > > and the restore is: > > C:\"program files"\firebird\firebird_2_5\bin\gbak -R -v -user SYSDBA > -pas masterkey C:\backups\Buford\Thursday\customer.bak > localhost:c:\temp\customer
What is the result of gstat -h on the production database? Thomas > Jack > > > > On 6/11/2015 9:01 AM, 'Thomas Steinmaurer' [email protected] > [firebird-support] wrote: >> >> >> > 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. >> >> You mean a physical file copy from Linux to Windows while the database >> is in use? >> >> > 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. >> >> And you don't call a different gbak version by accident, e.g. due to a >> set PATH environment variable etc.? >> >> Regards, >> Thomas >> >> > Jack >> > >> > On 6/11/2015 3:02 AM, Thomas Steinmaurer [email protected] >> > [firebird-support] wrote: >> >> >> >> 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 >> >> > >> >> > >> >> > >> >> >> >> >> > >> > -- >> > "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 >> > >> >> > > -- > "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 >
