Thanks for your response, Todd.

We have some sites which have multiple databases and programs on the one
machine. Shutting down Interbase would stuff up the other program... Looks
good if you're the only one on the box though...

Is there a way to know (Windows API, or IBObjects?) whether the current
database file is in use? This would need to include database cache writes,
etc...

Cheers.
Anthony

----- Original Message -----
From: "Todd Brasseur" <todd@...>
Newsgroups: egroups.ib-support
Sent: Tuesday, March 18, 2003 10:28 AM
Subject: Re: [ib-support] Backup and restore of a database


> My batch file does:
>
> 1) deletes old backups
> 2) uses gfix to shut down the database
> 3) uses net stop to stop the Guardian Service
> 4) copies existing database to a backup folder (in case something goes
> wrong)
> 5) uses net start to start the Guardian Service
> 6) Backs up the database
> 7) Restores the database
>
> This has worked fine for me.
>
> Todd
>
> Anthony Ison wrote:
>
> > Hi all,
> >
> > I'm looking to automatically backup and restore a database after an
> > upgrade.
> >
> > My first attempt at achieving this has met with almost complete failure.
> > My approach has been as follows:
> > 1. Backup the database (db1.gdb).
> > 2. Restore to another file (db2.gdb)
> > 3. Copy db1.gdb to db1.gdb.bak
> > 4. Copy db2.gdb to db1.gdb
> >
> > Unfortunately, this approach has produced a significantly high number of
> > corrupt databases. I believe it is to do with the fact that I'm copying
a
> > database, that could potentially have a number of connections open while
> > this is going on.
> >
> > I want to introduce more tests, etc that will guarantee a non-corrupt
> > database at the end of the process. This should be the original file
> > if the
> > backup and resotre was not successful. I would like to be able to do
this
> > on a remote machine except, I don't trust the backups produced (there
> > is no
> > guarantee they will restore) and I am not really prepared to wait for
the
> > database to restore to a temp location and then restore to the location
I
> > want...
> >
> > What do others do to regularly maintain their databases? Is a backup
and
> > restore enough? How do you guarantee the system is not in use when you
> > start a backup and restore? How do you stop someone from using your
> > system
> > once the backup and restore has been started?
> >
> > Any help is greatly appreciated!
> >
> > Thanks
> > Anthony
> >
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
<http://rd.yahoo.com/M=246920.2960106.4328965.2848452/D=egroupweb/S=17051153
86:HM/A=1464858/R=0/*http://www.gotomypc.com/u/tr/yh/cpm/grp/300_Cquo_1/g22l
p?Target=mm/g22lp.tmpl>
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> > <http://docs.yahoo.com/info/terms/>.
>
>
> --
> Todd Brasseur, A.M.A.A.
> COMPASS Municipal Services Inc.
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>