| Subject | Re: [firebird-support] nbackup |
|---|---|
| Author | Alexey Kovyazin |
| Post date | 2017-06-02T08:53:50Z |
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.
nbackup -n
In 2.5 nbackup of any level scans the whole database file.
Consider to migrate to 3.0 to take advantage of nbackup improvements
Regards,
Alexey Kovyazin
IBSurgeon
www.ib-aid.com
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 ifit's stuck?
nbackup -n
>I noticed that the larger the database is the longer ittakes to do nbackup even if the delta is very small.
In 2.5 nbackup of any level scans the whole database file.
Consider to migrate to 3.0 to take advantage of nbackup improvements
Regards,
Alexey Kovyazin
IBSurgeon
www.ib-aid.com
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 recover if it's stuck?
I noticed that the larger the database is the longer it takes to do nbackup even if the delta is very small.
BR,hugo