| Subject | Re: [firebird-support] Concerns about Firebird database to get perform with less downtime. |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2018-11-13T10:49:32Z |
On 2018-11-13 10:58, Marcelo Guimaraes mfguimaraes@...
[firebird-support] wrote:
**not** overwrite your existing database after each backup. The advice
to restore the database (to some temporary location) is to double check
that the backup is restorable (certain logical corruptions can allow a
backup to be created but not fully restored, which would be annoying to
find out if you have an emergency).
Mark
[firebird-support] wrote:
> I'm quite new on Firebird world and I have doubts about the databaseWhat do you mean? Creating a backup **is** online, and you should
> maintenance.
> I would like some advices what I should concern and periodically
> execute on the database to leave them working and performing well.
> As a read one way to do this is doing a maintenance doig "gbak -b" and
> "gbak -c", but I want something that can be online, to reduce the
> downtime.
**not** overwrite your existing database after each backup. The advice
to restore the database (to some temporary location) is to double check
that the backup is restorable (certain logical corruptions can allow a
backup to be created but not fully restored, which would be annoying to
find out if you have an emergency).
Mark