×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

interbase 5.0 backup and restore problem

interbase 5.0 backup and restore problem

interbase 5.0 backup and restore problem

(OP)
Hi all,


I am testing the backup and restore functions for interbase.
I created a backup using gbak.
And I restored the backup with the IB Expert / Services / Restore
function.
I had no error messages whatsoever neither for the backup nor for the
restore.
But I can't add new records over the software using the database. In
the database i can still add records to the table but the ID_generators
dont work anymore.
I recompiled the generators - no effect.
I validated the database - no errors
The database is online and in read/write mode.


Any suggestions what the problem might be ?


Thanks for your help.


Thanks Whitebat

RE: interbase 5.0 backup and restore problem

(OP)
Ok i found my problem. Triggers, views and procedures are not included in the backup.

my backup statement looks like this:

gbak -b -v -e -t -user sysdba -password masterkey  -y c:\integreattransport%date:~-4%%date:~4,2%%date:~7,2%.log dbnhtsa.gdb c:\dbnhtsatransport%date:~-4%%date:~4,2%%date:~7,2%.gbk

it makes no difference if i do a compact/full backup, transportable or non transportable backup they are never included.

Any suggestions?

Thanks Whitebat

RE: interbase 5.0 backup and restore problem

OK, so what happens when you manually run a backup using IBConsole's UI rather than using gbak ?

RE: interbase 5.0 backup and restore problem

(OP)
The exact same happens. :(.

Thanks Whitebat

RE: interbase 5.0 backup and restore problem

Hm, tricky. Needless to say that this shouldn't happen - the one time I saw it was when someone used a FireBird UI tool to restore an InterBase database winky smile

What about going the whole hog, shutting down the database and transferring it onto a 'clean' IB install and trying a backup/restore cycle ?

...and yes this is definitely a 'quick-fix-try-it-and-see' approach for which I make no apology smile, if this fails then the next thing to do is go through the process step-by-step in a more logical manner than how I have done thus far

ujb

RE: interbase 5.0 backup and restore problem

(OP)
That might be the problem then. The manufacturer of the software using the Interbase Database is using the firebird tools.

But we fixed it differently. We have a task that shuts down the database copies the file and opens the database again. That works good so far.
:)

Thanks Whitebat

RE: interbase 5.0 backup and restore problem

Jolly good show. I guess one other thing you could do to avoid similar issues in the future is to make sure that the complete backup/restore cycle is logged and appropriate notification set up (say via email using something like blat), i.e. a batch file that carries out the required tasks and sends a notification to the DBA if any of them fails.

For what its worth here is what my batch file does:

1) Shutdown the database
2) Do an IB backup of the database into the 'backup' folder
3) Do an IB backup of the InterBase security admin database into the 'backup' folder
4) Restart the database
5) Do an IB restore of the backed up database from step 2) into the 'backup' folder
6) Do an IB restore of the backed up InterBase security admin database from step 3) into the 'backup' folder
7) Shut down the InterBase Guardian service
8) Delete temporary sort files (if any exist)
9) Start up the InterBase Guardian service

Then you are in a position to OS backup the output of step 2 or 5 (depending upon how fast you need to recover the last backup) secure in the knowledge that a restore will work 100%.

good luck

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close