Colin,

C> So, what you are in effect saying is that my backups might be totally
C> useless because I might not be able to restore them even though the
C> backup worked correctly...

C> So, say I had a hard drive failure (which we recently had), just because
C> I had a successful backup doesn't mean I am going to have a successful
C> restore? That makes my legs go wobbly (and makes me want to rethink
C> using IB/Firebird!). Please tell me it isn't true!

C> If it is, we are going to have to have to have a policy of restoring
C> every backup to make sure all is well... And then do some serious
C> thinking!

I don't see it as tragic a thing as you seem to do. Just assume that a
restore on a different file is part of your backup process, just as you
learned you had to use gbak instead of an operating system file copy.

I usually take advantage of the fact I have to restore anyway and use the
newly restored database in place of the old one. In some circumstances
the server benefits from that.

Alternatively, you could use a tool like dbak.

Ciao
--
Nando mailto:nandod@...