Hello, Dmitry. You are right. Now a days gbak indeed takes arounda five 5 minutes.
I was thinking about use nbackup for additional "log". I would make incremental backup every 5 minutes (for example) and so I could restore the db situation in any 5 minutes I need. Is it a good idea? Em 26/06/2013 18:52, Dmitry Kuzmenko escreveu: > > 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 SATA II drives (1 for db and 1 > for backup), not for cool RAID storage, or even for SSD - there > usual backup and restore speed will be like lightning. > > You may start to think about nbackup when your db will reach ~20gb > size. > > HE> Could you help me with the nbackup? > HE> What the best use? Keys, frequency, etc... > HE> How to restore? > > read > http://www.firebirdsql.org/manual//nbackup.html > as many times, until you will understand it. > > nbackup -b 0 > is kinda file copy, with the near same speed > nbackup with higher levels will read whole db, but write only changes, > so, it is faster. > But, if you use Classic, consider not to use nbackup with Firebird > less than 2.5.2 (or even 2.5.3). > > -- > Dmitry Kuzmenko, www.ib-aid.com > > -- Atenciosamente, Hugo Eyng [Non-text portions of this message have been removed]
