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



Jack

 

> 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 ts@...
> [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 <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
>

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