Hi,
I have a problem and my ideas to solve it are getting to an end. Hopefully you
can help me.
When I try to make a backup with nbackup on our customer’s system (Windows
Server 2016 – Firebird 3.0.3) we get the following message, while we are
connected to the database with the
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
Hi,I have Implemented NBackup in one of my client's Central Database which will
be connected by more than 150 Remote Locations, Web Services Etc.Database Size
- 40GBOS - Windows 2012, 32 GB RamFirebird - 2.5.6
CSNBackup Frequency - Level 0 - Sundays, Level 1
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
> 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
>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.
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
> 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
> 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
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
>
> 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,
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:
>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 ?
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.
Hi,
I'm having a problem assessing a database due a missing delta file in our
datacenter.
I have tried the flowing commands to repair the database without success.
nbackup -F 506408949.mycloudpie.com
Failure: Database is not in state (2048) to be safely fixed up
nbackup -N
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
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
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
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
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
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 have many hundreds of
[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
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
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
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
C:\temp\MyDB_Level_0.nbk
If I remove localhost: then it works, but that would be running as
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
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,
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
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
Hi All,
We use nbackup to pull live copies of customer's production databases back to
our office to play with and help with support. We run a level0 backup every
weekend, and a level1 every day which are both copied back to the office over
night. That just leaves us to run a level2 when we
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
Hello,
I have encountered a serious problem with nbackup.
During a automated nbackup something happened with the .delta file and the
database was inaccessible until i luckily found the command nbackup.exe -U
which addressed the problem. Nothing else worked.
The error message was that the .delta
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
Hi all
I am using nbackup with a script to do a daily backup of my database.
I have a situation where the delta file still exists now and the files are
db.fdb size 309 555 date 22 April
db.fdb.deltasize 22 500 date 27 May
The last nbackup file is dated 22 April so it failed on
Hi
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 notional in size.
But as far
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
Hi
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 stores the version number for the
backup level.
From a quick search, I suspect that will be
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
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 don't need a lot of backup levels to do what
Hi
There is no formal limit, ...
Is there a negative effect on too many levels?
(Slowdown or database storage overhead?)
Regards,
Steffen
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
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
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
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,
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
Hi
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 between servers.
I could simply create backups with
Using Firebird 2.5 Superserver on a Windows 2003 server, when I attempted a
full backup (level 0) restore from a 90GB .nbk, the process aborted after
about an hour, providing only Error (1450) as an explanation. I don't see
error number definitions in the nBackup guide. Are they documented
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
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.
My first idea was to daily backup and begin with
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
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
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
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
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
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
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
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
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,
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
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,
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
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
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
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
Hi Everyone,
I can't see the default option for Direct I/O in my system. On or Off? It's
an ubuntu 64bit with firebird 2.5.0 classic.
There's a story about it in the nbackup-backups file but I can't clearly
figure out and be sure what the default is.
It's no big deal but,
Maybe it
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
Good Afternoon
I'm trying to run nBackup Firebird through command line below
C: \ nbackup.exe-U sysdba-P masterkey-B 0 C: \ nomedobanco.FDB C: \
nomedobackup.TMPNBK
but it appears to me the following error
The application failed to initialize properly (0xc07b). Click OK to
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
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,
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
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
Hello, im from Brazil and our company use NBackup, but we having some
issues. I tried to google it, but nothing usefull came, so I decide to talk
to the designer. 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
Hello, i'm from Brazil and our company use NBackup, but we having some issues.
I tried to google it, but nothing usefull came, so I decide to talk to the
designer. We have Firebird 2.5.2.26540, using SuperClassic, 70 users, our
database file has 2GB, we schedule nbackup every 20 minutes to make
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
Hi,
Not sure this ever got posted before; trying again.
I have a large FB 2.1 database, ODS 11.1.
I previously had some problems with nbackup in 2.1 so I have now made a
side by side install of FB 2.5 and want to try out nbackup on this DB.
The DB file will be accessed only by the 2.5 server
Hi,
I have a large FB 2.1 database, ODS 11.1.
I previously had some problems with nbackup in 2.1 so I have now made a
side by side install of FB 2.5 and want to try out nbackup on this DB.
The DB file will be accessed only by the 2.5 server in classic mode, but
I would initially like to not
Hi *,
I have a Firebird database, that was copied using alter database
begin backup copy alter database end backup. Now I want to
restore it, but if I try nbackup -F test.fdb I get Failure: Error
(5) opening database file: test.fdb. Which is completely utterly
useless. There's no documentation
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
Hi all,
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 ?
Regards,
Michal
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
Hi all
Does any one know of a scheduler that uses Nbackup?
There are a couple that use GBak (like FIBS or GBakScheduler etc.) but I
was hoping something similar exists for NBackup
Free, commercial, demo anything
Thanks
Tony
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
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
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 id (158048), errno: 22
--Invalid argument
attempts to do subsequent level 1 backups produced:
unsuccessful metadata update
-Database is
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
86 matches
Mail list logo