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