Subject | Database consistency check |
---|---|
Author | Steffen Heil |
Post date | 2009-08-29T22:01:32Z |
Hello
I am doing scripted database backups using multilevel nbackup.
Since these backups need to go through some slow links, I cannot transfer
the whole database at once, but I am only transferring the newest update
levels. That is
0. Every first Sunday of a quarter.
1. Every first Sunday of a month.
2. Every Sunday.
3. Every day.
(On some servers: 4. Every hour.)
These files are copied over a slow network link just after creation,
therefor only 3 times a year a full backup file needs to be transferred.
Now I am searching for a way to check these backups on the receiving end. So
I have some questions:
1. Is it possible to rebuild a database from the nbackup-files WITHOUT
having firebird installed as a daemon?
2. Is it possible to check the resulting database files for consistency that
I can be absolutely certain, that these work?
This sounds more easy as it is, because
a) The backup server hosts backups for possilbly multiple firebird
versions...
b) The backup server does not need to be the same platform (64 vs 32bit,
linux vs windows).
I could keep all files from the different firebird versions on the backup
server to use the appropriate version for each servers backups, however as
there are multiple servers involved, I would not want to install multiple
firebird servers as daemons.
Best Regards,
Steffen
[Non-text portions of this message have been removed]
I am doing scripted database backups using multilevel nbackup.
Since these backups need to go through some slow links, I cannot transfer
the whole database at once, but I am only transferring the newest update
levels. That is
0. Every first Sunday of a quarter.
1. Every first Sunday of a month.
2. Every Sunday.
3. Every day.
(On some servers: 4. Every hour.)
These files are copied over a slow network link just after creation,
therefor only 3 times a year a full backup file needs to be transferred.
Now I am searching for a way to check these backups on the receiving end. So
I have some questions:
1. Is it possible to rebuild a database from the nbackup-files WITHOUT
having firebird installed as a daemon?
2. Is it possible to check the resulting database files for consistency that
I can be absolutely certain, that these work?
This sounds more easy as it is, because
a) The backup server hosts backups for possilbly multiple firebird
versions...
b) The backup server does not need to be the same platform (64 vs 32bit,
linux vs windows).
I could keep all files from the different firebird versions on the backup
server to use the appropriate version for each servers backups, however as
there are multiple servers involved, I would not want to install multiple
firebird servers as daemons.
Best Regards,
Steffen
[Non-text portions of this message have been removed]