Subject Re: Is it safe to backup a database from another firebird server?
Author Juan Jose Ochoa
--- In, David Johnson
<johnson_d@c...> wrote:
> On Fri, 2005-08-12 at 19:42 +0000, Juan Jose Ochoa wrote:
> > Hi,
> >
> > I know two simultaneous engines can mess up a database. But, one
> > WRITE (On Production) and the other only doing frequent backups?
> What you want is called RAID.
> Lacking RAID, I believe that shadowing is an option in Firebird.
> will need to read Helen's book.

I replaced Shadowing by RAID three years ago. But this synchronous
way only protects me against disk failure. I need an asynchronous
backup in case of data corruption. That's why I'm doing gbak backups.
I do it from another computer because It takes one half of the time
than doing it in the same computer (server). you know, disk-writes
are in my local PC and doesn't take this time from the server.

> You do NOT want two engines competing for the same file, and the

Here is my question again:
If I do a backup of a database in server A from server B. am I doing
the two engines compete for the same database file?

Even if gbak does not _lock_ the file?

> > > > Also...
> >
> > Is it safe to run Northon Antivirus on a live firebird database?
> >
> Why would you run NAV on a database? Are you keeping code in the
> database?

The antivirus policy is a corporate policy and every computer in the
company must have it, unless I have a very good argument to take it
off. possible corruption, is a very good reason.


Juan Jose