asked on

Firebird Database Backup ?

Hi we have a client running 2 somewhat large databases on the Firebird platform.

My understanding is its an open source variant of SQL.

The database files are basically like this:

DATABASE1.FDB = 2Gig
DATABASE1STORAGE.FBD = 65Gig

I have been trying to find a nice utility to create daily BAK files of both of these databases.

DATABASE1.BAK
DATABASE1STORAGE.BAK

We then want to back these up offsite daily, rather than try to Shadow copy the FDBS etc

Anyone have experience here?
Thanks

ASKER CERTIFIED SOLUTION

mankowitz

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

IT SUPPORT

ASKER

Thanks I am aware of the GBAK util thanks so can I have it keep the same file name with overwrites daily?
Other 3rd party utils want to add date extensions this will get massive we want to snap a copy each day of the FBK file

Thanks

SOLUTION

Nick Upson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

mankowitz

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

IT SUPPORT

ASKER

Hi guys so trying to get this gbak syntax to work here is what I am trying: (subbed database name for ourdb)

gbak -v -t -g -user SYSDBA -password "ourdbpassword" server:/db/ourdb.fdb c:\temp\ourdb.fbk

Results:

gbak: ERROR:I/O error during "CreateFile (open)" operation for file "/db/ourdb.fdb"
gbak: ERROR: Error while trying to open file
gbak: ERROR: The system cannot find the path specified.
gbak:Exiting before completion due to errors

SOLUTION

Nick Upson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial