AW: [firebird-support] firebird sql alias for condition

2013-06-26 Thread Olaf Kluge
Thank you Set :o) One dataset includes a date + time to switch on and a date + time to switch off. I would like to get the timestamp next time on and next time off. In the simplest case both times from one dataset are in the future. Now it can be, that the next time to switch on listed in

Re: [firebird-support] GBak Backup Restore Problem

2013-06-26 Thread Tupy . . . nambá
Benson,   Thanks for insist for to have a solution for this.   We believe we found a pratical solution = for the first, we restored the DB structure only and after then, DB data only. This worked in a test machine, we believe this will work at a production machine. Today, we will see how we can

Re: [firebird-support] Incremental Backup

2013-06-26 Thread Nagy Szilveszter
Is your database so big that you need the speed nbackup gives you? Compare the speed with the integrity...which is more important in your scenario? Think about a failure of your database...how will you proceed at restoring? If it is a mission critical database you won't have too much time for

Re: [firebird-support] Incremental Backup

2013-06-26 Thread Hugo Eyng
This a good manner of thinking: a combination of two. My database size: 4 GB Could you help me with the nbackup? What the best use? Keys, frequency, etc... How to restore? Em 26/06/2013 15:13, Nagy Szilveszter escreveu: Is your database so big that you need the speed nbackup gives you?

Re[2]: [firebird-support] Incremental Backup

2013-06-26 Thread Dmitry Kuzmenko
Hello, Hugo! Thursday, June 27, 2013, 1:28:18 AM, you wrote: HE My database size: 4 GB I doubt to use nbackup for that size of database. because usual gbak -b -g must take around 5 minutes, not more. Restore of that db also must take around 15 minutes. And, the timing I mention is for cheap