Hi

For some reason I had convinced myself that I had produced a backup file that could be
read as a normal database, this was obviously not the case and I can't really see why I
thought so, probably a senior moment !.

When I played around with gbak one of the things that threw me was that the original
database was over 3MB but when backed up it reduced to about 67K, I convinced
myself that this couldn't be a full backup until I played around with restoring.

Thanks to some help from Helen I now produce a backup using the IBX
IBBackupService component and restore withIBRestoreservice producing a database
of around 800K, although gbak did work also.

My customer who requested this now backs up both the normal backup file and the
restored backup database on their network nightly.

I did also look at using a shadow copy of the database as a backup but I was worried
about what would happen if for some reason the database server did not have access
to the shadow file, for instance during nightly backups.

so thanks Aage and Helen for the help / advice.

Rgds

Peter

On 21 Jul 2004 at 21:52, Aage Johansen wrote:

> Peter wrote:
> > Hi
> >
> > I have suddenly started having problems calling gbak and I am not sure why.
> > Running on windows I call
> >
> > gbak -B -user SYSDBA -password masterkey sourcedb c:\backup.fdb
> >
> > sourcedb is an alias, however I have also tried an absolute path and
> filename
> > to the db. backups are running on the same machine as the server.
> > gbak does not report any errors.
> >
> > The problem seems to be that the backup database is created but that it
> is too
> > small and not a valid db when viewed in something like database workbench.
> > In a hex editor it is clear it is at least derived from my source db as
> i can see
> > my stored procedures etc in there.
> >
> > Any help / suggestions would be appreciated.
>
>
> The backup file produced by gbak is not in the usual firebird database
> format. Usually it is given a name with a different extension (e.g.
> backup.fbk (not backup.fdb)). Don't expect it to look like you original
> database!
>
>
> --
> Aage J.
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
> click here
>
>
>
>
>
>
>
> Yahoo! Groups Links
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>


--
=================================================
Peter Chaisty e-Mail: peter@...
-------------------------------------------------
Cyionics Ltd UK
Tel: +44(1)1495 785570
All email is scanned using Norton Antivirus
=================================================