[firebird-support] nbackup questions

2014-01-15 Thread Maury Markowitz
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 system off an unstable machine. FBI does not allow me to simply replace the .FDB files, for reasons that have not been explained (error codes that make no sense). I

Re: [firebird-support] nbackup questions

2014-01-15 Thread Hugo Eyng
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

2014-01-15 Thread Maury Markowitz
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

2014-01-15 Thread Alexandre Benson Smith
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

2014-01-15 Thread Maury Markowitz
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

2014-01-15 Thread Maury Markowitz
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

2014-01-15 Thread Paul Vinkenoog
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

2014-01-15 Thread Maury Markowitz
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

2014-01-15 Thread Maury Markowitz
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

2014-01-15 Thread Paul Vinkenoog
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

2014-01-15 Thread Maury Markowitz
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

2014-01-15 Thread Hugo Eyng
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

2014-01-15 Thread Maury Markowitz
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

2014-01-15 Thread Paul Vinkenoog
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