Very Computer

> Bernhard, I understand your concern about making sure all users are
> out of the system before performing a backup. However, your concern
> about users being thrown out confuses me. From your post, I gather the
> conditional shutdown you mention would be intended to delay or skip
> the backup. Good backups are far more important than disconnected
> users.

> However, as an alternative, you might try Backup Exec's Btrieve
> extension. I have seen it successfully backup files while users have
> them open. Arcserve's DBAgent DOES NOT WORK for this purpose. Backup
> Exec is the only program I know of that can do this.

> > we would like to do a scheduled backup every night but make sure
> that:

> > 1.) no user is connected to the database during the backup
> > 2.) no user is thrown out by the backup ( from time to time there
> are long
> > jobs running over the night)

> > We don't want to use continuous operation because normally the
> database is
> > not in use during the night, so an offline backup is perfectly
> sufficient.

> > 1.) is easy, I can stop the Btrieve and PSQL engine before the
> backup and
> > start it again afterwards
> > 2.) is my problem. Is it possible to check for active users of the
> Btrieve
> > and PSQL engine or do a conditional shutdown only if no user is
> connected
> > (or better: if no user has any table in use. If users forgot to log
> out they
> > should be thrown out if they have no tables in use)

> > any suggestions ?

> > thanks

> > --
> > Bernhard Mandl
> > Global Refund IT / Vienna

> Do you know how Backup exec makes sure that the backup of the open
file is
> really usable ?

> I generally don't trust tricky solutions.

> thanks

> Bernhard

> > Bernhard, I understand your concern about making sure all users
are
> > out of the system before performing a backup. However, your
concern
> > about users being thrown out confuses me. From your post, I gather
the
> > conditional shutdown you mention would be intended to delay or
skip
> > the backup. Good backups are far more important than disconnected
> > users.

> > However, as an alternative, you might try Backup Exec's Btrieve
> > extension. I have seen it successfully backup files while users
have
> > them open. Arcserve's DBAgent DOES NOT WORK for this purpose.
Backup
> > Exec is the only program I know of that can do this.

> > > we would like to do a scheduled backup every night but make sure
> > that:

> > > 1.) no user is connected to the database during the backup
> > > 2.) no user is thrown out by the backup ( from time to time
there
> > are long
> > > jobs running over the night)

> > > We don't want to use continuous operation because normally the
> > database is
> > > not in use during the night, so an offline backup is perfectly
> > sufficient.

> > > 1.) is easy, I can stop the Btrieve and PSQL engine before the
> > backup and
> > > start it again afterwards
> > > 2.) is my problem. Is it possible to check for active users of
the
> > Btrieve
> > > and PSQL engine or do a conditional shutdown only if no user is
> > connected
> > > (or better: if no user has any table in use. If users forgot to
log
> > out they
> > > should be thrown out if they have no tables in use)

> > > any suggestions ?

> > > thanks

> > > --
> > > Bernhard Mandl
> > > Global Refund IT / Vienna

> Sorry, I can't say for sure. But I do have quite a few clients using
> this solution on NT without issue. Maybe Backup Exec could give you a
> better answer.

> > Do you know how Backup exec makes sure that the backup of the open
> file is
> > really usable ?

> > I generally don't trust tricky solutions.

> > thanks

> > Bernhard

> > > Bernhard, I understand your concern about making sure all users
> are
> > > out of the system before performing a backup. However, your
> concern
> > > about users being thrown out confuses me. From your post, I gather
> the
> > > conditional shutdown you mention would be intended to delay or
> skip
> > > the backup. Good backups are far more important than disconnected
> > > users.

> > > However, as an alternative, you might try Backup Exec's Btrieve
> > > extension. I have seen it successfully backup files while users
> have
> > > them open. Arcserve's DBAgent DOES NOT WORK for this purpose.
> Backup
> > > Exec is the only program I know of that can do this.

> > > > we would like to do a scheduled backup every night but make sure
> > > that:

> > > > 1.) no user is connected to the database during the backup
> > > > 2.) no user is thrown out by the backup ( from time to time
> there
> > > are long
> > > > jobs running over the night)

> > > > We don't want to use continuous operation because normally the
> > > database is
> > > > not in use during the night, so an offline backup is perfectly
> > > sufficient.

> > > > 1.) is easy, I can stop the Btrieve and PSQL engine before the
> > > backup and
> > > > start it again afterwards
> > > > 2.) is my problem. Is it possible to check for active users of
> the
> > > Btrieve
> > > > and PSQL engine or do a conditional shutdown only if no user is
> > > connected
> > > > (or better: if no user has any table in use. If users forgot to
> log
> > > out they
> > > > should be thrown out if they have no tables in use)

> > > > any suggestions ?

> > > > thanks

> > > > --
> > > > Bernhard Mandl
> > > > Global Refund IT / Vienna

> we would like to do a scheduled backup every night but make sure that:

> 1.) no user is connected to the database during the backup
> 2.) no user is thrown out by the backup ( from time to time there are long
> jobs running over the night)

> We don't want to use continuous operation because normally the database is
> not in use during the night, so an offline backup is perfectly sufficient.