Re: [firebird-support] NBackup Backup Takes Long Time For Level 2.

15.11.2017 7:49, Anto Edin Charley antoedinchar...@gmail.com [firebird-support] wrote: > For every Level 2 Backup it takes more than 30 Minutes to complete. Is there > anything i > need to Check/Improve 1) Try switch -d. NBackup should work at disk's speed. 2) You can migrate to Firebird 3

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

04.08.2017 20:37, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > Unfortunately, in your later post you suggested that nbackup is never safe to > use. Sure, as any other software it may have destructive bugs. Every software license has words like "this software is

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

> El 4 ago 2017, a las 19:05, Dimitry Sibiryakov s...@ibphoenix.com > [firebird-support] escribió: > > 04.08.2017 18:52, Jesus Garcia jeg...@gmail.com [firebird-support] wrote: >> As I understood he was saying to not use nbackup, and if one person involved

RE: [firebird-support] nbackup : Error assessing database due a missing delta file

>There is a difference between "do not use it" and "do not use it with this > version". Unfortunately, in your later post you suggested that nbackup is never safe to use.

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

04.08.2017 18:52, Jesus Garcia jeg...@gmail.com [firebird-support] wrote: > As I understood he was saying to not use nbackup, and if one person involved > in any way to > firebird says not to use it, then what make him think to others? There is a difference between "do not use it" and "do

RE: [firebird-support] nbackup : Error assessing database due a missing delta file

> Hello Sean, I was replying to dimitry s. Have you read his response? > > As I understood he was saying to not use nbackup, and if one person > involved in any way to firebird says not to use it, then what make him think > to others? Let's just say that I find Dimitry S POV on many subject

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

> El 4 ago 2017, a las 16:54, 'Leyne, Sean' s...@broadviewsoftware.com > [firebird-support] escribió: > > > I only see three items pending, but anyway, why not remove Nbackup from > > firebird until it is safe to use? > > As others have pointed out, the

RE: [firebird-support] nbackup : Error assessing database due a missing delta file

Jesus Garcia, > I only see three items pending, but anyway, why not remove Nbackup from > firebird until it is safe to use? As others have pointed out, the latest FB versions have an updated nbackup > Why is there a tool that cannot be used in a safe way? Q1: How do you *know* if a tool is

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

> > Always use the latest release. For 2.5 it is 2.5.7. But even with this it is > not > guaranteed to work. Check list of nbackup-related bugs in tracker: > http://tracker.firebirdsql.org/secure/IssueNavigator.jspa?sorter/field=updated/order= > I only see three items pending, but anyway,

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

03.08.2017 11:00, Jorge Gonçalves projo...@gmail.com [firebird-support] wrote: > From which version is safe to use nbackup ? Always use the latest release. For 2.5 it is 2.5.7. But even with this it is not guaranteed to work. Check list of nbackup-related bugs in tracker:

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

>Restore your database from backup and never use nbackup with this bugged FB version any >more. Done ... >From which version is safe to use nbackup ?

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

02.08.2017 15:20, Jorge Gonçalves projo...@gmail.com [firebird-support] wrote: > Any idea how to prevent this problem to appear again in the future ? > > FB Version : 2.5.2.26539 Restore your database from backup and never use nbackup with this bugged FB version any more. -- WBR, SD.

Re: [firebird-support] nbackup

Hi, Interesting that FB 3.0 reduces the nbackup time. Thanks for the info. We have so many installations so I think we will wait for FB 4.0 which have incremental nbackup restore and native replication. BR, Fadi

Re: [firebird-support] nbackup

Hi Hugo, Yes, in this case you can check MON$ tables. Please note that in case of many connections query to MON$ can consume significant resources. How do you recover if it's stuck? nbackup -n >I noticed that the larger the database is the longer it takes to do nbackup even if the delta

Re: [firebird-support] nbackup

Hi Alexey, In my case the database is seldom larger 500 MB and the backup takes 30 maximum seconds. Would it not be sufficient to check the MON$BACKUP_STATE field (thanks Thomas) and if its stuck on state 1 or 2 for several minutes then I execute "ALTER DATABASE END BACKUP". How do you

Re: [firebird-support] nbackup

Hello, > Hello, > > Is there a way to ask a database if someone is performing a nbackup? > > If it's in "the physical backup mode". > > I'm always paranoid if there is a power failure during a backup and it > gets stuck in that mode and I would like it to recover from such situation. > We

Re: [firebird-support] nbackup

Hi Hugo, In HQbird, we monitor size and age of delta files. If it is bigger or older than appropriate size/age (like 500Mb/6 hours, for example), the database is marked as critical in Control Center. You can implement the same - the status of the database and path to delta file can be

Re: [firebird-support] "nbackup needs local access to database file"

[firebird-support] To: firebird-support@yahoogroups.com Sent: Sunday, September 11, 2016 5:11 PM Subject: Re: [firebird-support] "nbackup needs local access to database file" On 10-9-2016 23:34, fabia...@itbizolutions.com.au [firebird-support] wrote: > I am getting this error

Re: [firebird-support] "nbackup needs local access to database file"

On 11-9-2016 09:11, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Gbak and nbackup are different tools that work in a different way. Gbak > works through a Firebird server (real or embedded), while nbackup works > with the physical backup file. That should have been "physical

Re: [firebird-support] "nbackup needs local access to database file"

On 10-9-2016 23:34, fabia...@itbizolutions.com.au [firebird-support] wrote: > I am getting this error while running nbackup: > > "nbackup needs local access to database file" > > The nbackup sentence is: > > Nbackup.exe -user SYSDBA -pas HereMyPass -B 0 > localhost:MyDB_FB3.fdb

Re: [firebird-support] nbackup problem : Database is already in the physical backup mode

Hi Hugo, So if the computer is shutdown during a nbackup the database is locked in this way indefinelty? Yes, it's one of the most prevalent problems with nbackup. To prevent it you need to monitor delta file age and size - manually, or automatically using our FBDataGuard tool. What

Re: [firebird-support] nbackup problem : Database is already in the physical backup mode

Hello Mark, So if the computer is shutdown during a nbackup the database is locked in this way indefinelty? What do you suggest I should do with JayBird when the exception is thrown? Execute alter database end backup? BR,

Re: [firebird-support] nbackup problem : Database is already in the physical backup mode

On 27 Mar 2015 01:24:06 -0700, hugo.lar...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote: We have a POS application using Firebird 2.5.3 together with JayBird on about 300 sites. The applications runs nbackup several times everyday. It has happened several times on

Re: [firebird-support] nbackup problem : Database is already in the physical backup mode

On 27 Mar 2015 02:52:54 -0700, hugo.lar...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote: So if the computer is shutdown during a nbackup the database is locked in this way indefinelty? As far as I know: yes, until you manually end the physical backup mode. What do you

Re: [firebird-support] nbackup and lost indexes

What is you firebird version? AFAIK the only working version, whit no bugs, is 2.5.3 So, try updating customer's Firebird and try again. Em 04/12/2014 13:10, wobble...@yahoo.co.uk [firebird-support] firebird-support@yahoogroups.com escreveu: Hi All, We use nbackup to pull live copies of

Re: [firebird-support] nbackup database made database inaccessible

Hello, If you have moved or deleted .delta-file, you got the correct message. If delta file was corrupted, or database was corrupted in the way which prevent merge, there could be various error messages. Check your database with gfix -v -full now, to be sure it's Ok. Is it risky to run a

Re: [firebird-support] nbackup

RE: [firebird-support] NBackup Levels

But as far as I understand, the database has to track which page changes since which backup. Correct, but that information is actually stored as a version number in the header of each data page. When page data changes the version number is changed. The nbackup database structure only

RE: [firebird-support] NBackup Levels

From a quick search, I suspect that will be the pag_scn 4 byte value. I don't recall exactly, if you want to pursue this you should ask on the Devel list for confirmation. That would mean that I could relatively easily write my own sync code that could also read all those values and decide

Re: [firebird-support] NBackup Levels

Steffen Heil (Mailinglisten) skriver: Hi I could simply create backups with incrementing levels, move the backup to the other server(s) and apply them there (that database is offline). However, I suspect there is a limit for the number of backup levels a database can have. You

RE: [firebird-support] NBackup Levels

I understand your problem. Would it be possible to measure the size of each level 5 backup, and if it's over a certain threshold use a higher level for the rest of that day to keep from copying the same large set of data over and over? In essence, you would create a script that backs up every

RE: [firebird-support] NBackup Levels

There is no formal limit, ... Is there a negative effect on too many levels? (Slowdown or database storage overhead?) No negative effect. The database does track the ID of the last backup at each level, so you would have 2 or 3 more entries that the typical usage, but the details are

Re: [firebird-support] NBackup Levels

Every operating system has some limit on environment strings like command line, that can be a problem on restore where the every level's filename should be supplied. Not sure if it's a theoretical or practical problem in Your case. I use 3 levels (0 - friday night, 1 - every other weekday night,

Re: [firebird-support] NBackup Levels

Den 2014-05-05 22:27 skrev Steffen Heil (Mailinglisten) såhär: I know that nbackup keeps track of which blocks in the database changed and which did not so that backups contain only the blocks that changes since the last backup of the next lower level. I want to use that feature to do syncs

Re: [firebird-support] nbackup strategy advice

Hello, Hello, We have a POS applications with hundreds of clients and need some advice on how to backup. Each application has it's own Firebird database. Read about nbackup and thought that this could be a solution since the clients has low bandwidth. I'm not entirely sure if I understand

Re: [firebird-support] nbackup strategy advice

Hello Hugo, We have a POS applications with hundreds of clients and need some advice on how to backup. Each application has it's own Firebird database. Read about nbackup and thought that this could be a solution since the clients has low bandwidth. My first idea was to daily backup and

Re: [firebird-support] nbackup questions

Hi. I am not sure if i understood your question. You want to move the fdb file to another computer? Hugo Eyng Em 15/01/2014 12:52, Maury Markowitz escreveu: I am a admin of the Fishbowl Inventory (FBI) system for our company, which is a Java app on top of Firebird. I need to move the

Re: [firebird-support] nbackup questions

On 2014-01-15, at 2:02 PM, Hugo Eyng wrote: I am not sure if i understood your question. You want to move the fdb file to another computer? That is correct. For reasons that I do not understand, the simple method of simply copying the FDB from one machine to another does not work. When I

Re: [firebird-support] nbackup questions

Em 15/1/2014 17:30, Maury Markowitz escreveu: On 2014-01-15, at 2:02 PM, Hugo Eyng wrote: I am not sure if i understood your question. You want to move the fdb file to another computer? That is correct. For reasons that I do not understand, the simple method of simply copying the FDB from

Re: [firebird-support] nbackup questions

On 2014-01-15, at 2:43 PM, Alexandre Benson Smith wrote: Take a look on nbackup (http://www.firebirdsql.org/manual/nbackup.html) manual so you could try to merge it back manually. Indeed, but that brings me back to the actual problem... I do not know the password for SYSDBA, and the only

Re: [firebird-support] nbackup questions

On 2014-01-15, at 2:43 PM, Alexandre Benson Smith wrote: Take a look on nbackup (http://www.firebirdsql.org/manual/nbackup.html) manual so you could try to merge it back manually. But wait... what about... ALTER DATABASE END BACKUP If I am reading it correctly, this appears to do the same

Re: [firebird-support] nbackup questions

Maury Markowitz wrote: But wait... what about... ALTER DATABASE END BACKUP If I am reading it correctly, this appears to do the same thing as nbackup -N. Is that correct? That is correct, but in order to issue that command you must connect to the database as SYSDBA or owner. From your

Re: [firebird-support] nbackup questions

On 2014-01-15, at 4:29 PM, Paul Vinkenoog wrote: Why don't you contact the administrator of the system in question? After all, *someone* should know the SYSDBA password, shouldn't they? I don't believe so. The installer process that created the DB, which comes from Fishbowl, not Firebird,

Re: [firebird-support] nbackup questions

On 2014-01-15, at 5:40 PM, hv...@users.sourceforge.net hv...@users.sourceforge.net wrote: This is too strong statement. To verify it we need to know physical backup state of the database. gstat -h will show it (and it not requires admin privileges). I am able to run this on the original

Re: [firebird-support] nbackup questions

Hello Maury, Why don't you contact the administrator of the system in question? After all, *someone* should know the SYSDBA password, shouldn't they? I don't believe so. The installer process that created the DB, which comes from Fishbowl, not Firebird, never asked for a SYSDBA password,

Re: [firebird-support] nbackup questions

On 2014-01-15, at 8:23 PM, Paul Vinkenoog wrote: I think you should contact Fishbowl Inventory support to clear this up. Indeed; they currently have a multi-hour phone wait time. Most keep it at masterkey though. In your case, I assume that the Fishbowl software has generated a secure

Re: [firebird-support] nbackup questions

There are some things you should observe: 1 - Use the same version of FB server in the computer you move the 'fdb' to that you use in the 'source' computer; 2 - Before copying the 'fdb' stop the FB server service; Another thing I would tell you is that you should use 'gbak' to backup your

Re: [firebird-support] nbackup questions

On 2014-01-15, at 8:23 PM, Paul Vinkenoog wrote: I think you should contact Fishbowl Inventory support to clear this up. So a little Google-fu was all that took. Now armed with the credentials, what would be the next steps at this point? I suspect the next step is to END BACKUP. However, I

Re: [firebird-support] nbackup questions

Hello Maury, So a little Google-fu was all that took. Now armed with the credentials, what would be the next steps at this point? I suspect the next step is to END BACKUP. However, I wish to tread carefully... I don't have a backup newer than last May, the existing FDB is not a usable

Re: [firebird-support] Nbackup, Default I/O ON or OFF

Hello, atunccekic! Friday, December 20, 2013, 12:35:54 PM, you wrote: adct It's no big deal but, adct Maybe it can be written in the help like : adct Use or not direct I/O when scanning database (Default: Off) I think there is a mistake, because nbackup is a part of Firebird server, so

Re: [firebird-support] NBackup

Hello, alessandroyamasaki! Friday, December 20, 2013, 8:16:17 PM, you wrote: agc I'm trying to run nBackup Firebird through command line below agc C: \ nbackup.exe-U sysdba-P masterkey-B 0 C: \ nomedobanco.FDB C: \ nomedobackup.TMPNBK exactly nbackup-U ? and other spaces/nospaces ? do you

Re: [firebird-support] NBackup

Hi Yes, I have access to the folder. Thank you for your attention. The problem was the quotes resolved C:\nbackup.exe -U sysdba -P masterkey-B 0 C:\nomedobanco.FDB C:\nomedobackup.TMPNBK []´s 2013/12/20 Dmitry Kuzmenko k...@ibase.ru Hello, alessandroyamasaki! Friday, December 20,

Re: [firebird-support] NBackup level 0 vs. file copy?

On Tue, 8 Oct 2013 12:37:57 +0200 Kjell Rilbe kjell.ri...@datadia.se wrote: Working with FB 2.5 on Windows 64 bit, how does Nbackup level 0 perform compared to a high-performance copy utility like FastCopy? I'm asking because my DB is 80+ Gbyte and both the database and the backup are

RE: [firebird-support] NBackup level 0 vs. file copy?

Dmitry, Tuesday, October 8, 2013, 2:37:57 PM, you wrote: KR Working with FB 2.5 on Windows 64 bit, how does Nbackup level 0 KR perform compared to a high-performance copy utility like FastCopy? as I see on my desktop nbackup -b 0 is 2-3 times slower than lock/file copy/unlock. I think

RE: [firebird-support] NBackup problem, causing deadlock

Matthias, We have Firebird 2.5.2.26540, using SuperClassic, 70 users, our database file has 2GB, we schedule nbackup every 20 minutes to make a incremental backup, after implantation we had a problem, on average once a day and happens deadlock and the firebird service stops and we have to

Re: [firebird-support] NBackup freezes OIT ?

I just made some nbackup tests (FB 2.5.2 SS, Windows XP) and noticed that whenever I use it to restore a database, it's Oldest transaction (OIT) gets stuck. It remains at the same value until next database sweep. Is it a bug or a feature ? I think the problem is here: What nbackup do is

Re: [firebird-support] NBackup freezes OIT ?

On Tue, Apr 16, 2013 at 4:48 AM, remk_1 rem...@yahoo.com wrote: I just made some nbackup tests (FB 2.5.2 SS, Windows XP) and noticed that whenever I use it to restore a database, it's Oldest transaction (OIT) gets stuck. It remains at the same value until next database sweep. Is it a bug or

Re: [firebird-support] nbackup failure - cause?

the level 0 backup restores ok and gbak will then backup restore that, could the corruption be somewhere that that doesn't matter? how can I find and deal with it? On 1 November 2011 09:47, Nick Upson nick.up...@gmail.com wrote: sorry, didn't think to say, its version 2.1.4 On 31 October

Re: [firebird-support] nbackup failure - cause?

Hello, Unfortunately, I can't say more without thorough investigation. It can be bug or corruption or misconfiguration. Regards, Alexey Kovyazin the level 0 backup restores ok and gbak will then backup restore that, could the corruption be somewhere that that doesn't matter? how can I find

Re: [firebird-support] nbackup failure - cause?

Hello Nick, It seems like you have database corruption. What is Firebird version? Regards, Alexey Kovyazin IBSurgeon (www.ib-aid.com) Hi, I have recently started using nbackup and have a system where, at the end of an attempt to do a level 0 I got Fatal lock manager error: invalid lock