Re: [firebird-support] Re: Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, hvlad@... wrote : ---In firebird-support@yahoogroups.com, jackmason@... wrote : Hmm... i'd say it is impossible to obtain such results using FIrebird. See below C:\Program Files\Firebird\Firebird_2_5\binisql -user sysdba -pass masterkey Use

RE: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
Unlike Vlad, Helen and Thomas, I know next to nothing about problems like yours (I'm good at SELECTs, which is way different from corrupted backups). Hence, listen more to them than to me. gbak:restoring privilege for user SYSDBA gbak: ERROR:action cancelled by trigger (3) to preserve data

Re: [firebird-support] Changing process priority

2015-06-12 Thread fabianoas...@gmail.com [firebird-support]
Realtime is only for SO process, it will mess the things, hang the system and so on. Em 11/06/2015 16:37, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] firebird-support@yahoogroups.com escreveu: Is it safe to change firebird’s process priority to “above normal” , “high” or

Re: [firebird-support] Re: Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Jack Mason jackma...@mindspring.com [firebird-support]
Thanks. We do have both Interbase and Firebird running on our Win7 machine because we have to access both types of databases. I will try your suggestion. Jack On 6/12/2015 3:22 PM, hv...@users.sourceforge.net [firebird-support] wrote: Jack, I strongly suggest you to check your Win7

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Jack Mason jackma...@mindspring.com [firebird-support]
Thanks. I will try it. Jack On 6/12/2015 2:50 PM, Ivan Arabadzhiev intelru...@yahoo.com [firebird-support] wrote: Last time I used http://fbexport.sourceforge.net/ and it worked like a charm 2015-06-12 19:22 GMT+03:00 Jack Mason jackma...@mindspring.com mailto:jackma...@mindspring.com

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Ivan Arabadzhiev intelru...@yahoo.com [firebird-support]
Last time I used http://fbexport.sourceforge.net/ and it worked like a charm 2015-06-12 19:22 GMT+03:00 Jack Mason jackma...@mindspring.com [firebird-support] firebird-support@yahoogroups.com: Thanks. That sounds much easier and faster than exporting everything, which has proven sort of

Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Jack Mason jackma...@mindspring.com [firebird-support]
Thank you very much. I will get a chance to try the -o switch this weekend when everyone goes home. Jack On 6/12/2015 2:25 PM, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: On 6/12/2015 2:11 PM, Jack Mason jackma...@mindspring.com [firebird-support] wrote: Thank you very

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Jack Mason jackma...@mindspring.com [firebird-support]
Ah... thanks for that info. So, export all the data and rebuild from scratch is the way to go? Jack On 6/12/2015 12:56 AM, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: At 08:57 a.m. 12/06/2015, Jack Mason jackma...@mindspring.com [firebird-support] wrote: We were

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread 'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support]
No: generate database DML scripts, create new database using these scripts and use a database pump utility to copy data from the old to the new. No need to start from scratch. Mark - Reply message - Van: Jack Mason jackma...@mindspring.com [firebird-support]

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Jack Mason jackma...@mindspring.com [firebird-support]
Thanks. That sounds much easier and faster than exporting everything, which has proven sort of unreliable in the past. Know where I can find a reliable data pump utility? Jack On 6/12/2015 12:09 PM, 'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support] wrote: No: generate database DML

Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Jack Mason jackma...@mindspring.com [firebird-support]
Thank you very much. I will try the -o switch and the gfix suggestion as well. Jack On 6/12/2015 2:08 PM, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: On 6/11/2015 11:05 AM, Jack Mason jackma...@mindspring.com [firebird-support] wrote: However, that won't help us.

Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On 6/12/2015 2:11 PM, Jack Mason jackma...@mindspring.com [firebird-support] wrote: Thank you very much. I will try the -o switch and the gfix suggestion as well. Don't bother with gfix. It does a physical database check - pointers point to what they should, pages are the right type,

Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On 6/11/2015 11:05 AM, Jack Mason jackma...@mindspring.com [firebird-support] wrote: However, that won't help us. Our concern is that we have been backing up our databases for years and it has been a fruitless exercise. We cannot restore them. We did not have that problem with Interbase

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-12 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On 6/11/2015 4:33 PM, Jack Mason jackma...@mindspring.com [firebird-support] wrote: Why is everyone else not having this problem? The databases are Firebird databases. For 15 years we had no corruption from Interbase 6. Two years ago, we backed up our databases with Interbase 6 gbak and