| Subject | RE: [firebird-support] Backup size bigger than restore size |
|---|---|
| Author | Helen Borrie |
| Post date | 2006-02-06T21:59:11Z |
Graeme Bruton wrote:
backup completed?
largish blobs that haven't been restored yet. Although the data
pages containing the "missing" records have been restored, they'll
remain inaccessible until the blob pages have been recreated and
filled. You wouldn't see them from a transaction that started before
they were restored.
Worse, if you try to perform any DML on records that you *can*
access, you will corrupt the database.
Since you used the -v[erify] option for your restore, did you watch
the output?
.........................................
Let's get more info about this statement:
8th December and the "current live database".
Have you tried running the restore again and using the -y switch with
a filename to direct the -verify output to a text file?
gbak -c -v /backup/database.fbk localhost:/opt/firebird/database1.fdb
-y /home/graeme/database1.blog
(Assuming of course that the firebird user has write perms on your home dir)
I hope you're not *really* storing databases in the Firebird root directory....
More questions than answers at this point.
./heLen
> > I need to restore a database that was backed up on the 8th December 2005,I'd smell a rat. Did you log into the recreated database before the
> > but not necessarily to the current live database. On the Fedora
> > Core 3 box,
> > I run gbak -c -v /backup/database.fbk
> > localhost:/opt/firebird/database.fdb,
> > but when I compare file sizes, the restored database is 485MB, and the
> > backup from the 8th is 1.4GB, and it looks like not all the data has come
> > back.
backup completed?
>Am I doing something wrong, or what is going on here?At 01:44 AM 7/02/2006, he wrote:
>Hi AlanOn the face of it, the restore is still running and you have some
>
>The fbk is bigger than the fdb I have just restored to. The database records
>and logs voice calls from a telephone, and certain calls going back further
>than a certain date are not playimg back.
largish blobs that haven't been restored yet. Although the data
pages containing the "missing" records have been restored, they'll
remain inaccessible until the blob pages have been recreated and
filled. You wouldn't see them from a transaction that started before
they were restored.
Worse, if you try to perform any DML on records that you *can*
access, you will corrupt the database.
Since you used the -v[erify] option for your restore, did you watch
the output?
.........................................
Let's get more info about this statement:
>I need to restore a database that was backed up on the 8th December 2005,What do you mean by that? Describe the difference in conditions on
>but not necessarily to the current live database.
8th December and the "current live database".
Have you tried running the restore again and using the -y switch with
a filename to direct the -verify output to a text file?
gbak -c -v /backup/database.fbk localhost:/opt/firebird/database1.fdb
-y /home/graeme/database1.blog
(Assuming of course that the firebird user has write perms on your home dir)
I hope you're not *really* storing databases in the Firebird root directory....
More questions than answers at this point.
./heLen