Seems like a lot of trouble to go to, Fred, when FB can do exactly
the same thing itself...

If you are determined to shutdown the db and deny access then simply:

gfix -shut -force n (n being time to wait til forced shutdown)
see also gfix -shut -tran n, gfix -shut -attach n

Do your gbak, or whatever, confident that there are no connections
(nobody but owner and sysdba can access the db) then bring it back up
with:

gfix -online

If you wanted to get fancy about it, you'd post an event notifying
clients something like "Shutting down for maintenance in XX minutes.
Please complete your work and exit immediately!" -- you don't want to
trash their current transaction.

Regards,
Andrew Ferguson
-- I can neither confirm nor deny this.

--- In ib-support@y..., "Wilson, Fred" <fred.wilson@b...> wrote:
> Without going into the "fine" details (IB/FB under NT and/or W2K)
> - We have a backup HOSTS file that does NOT have the gds entry in
it.
> - We have a .cmd file that does the following:
> - Stops the IB Service (under NT or W2K) via a "net stop
service"
> call
> - Rename the current HOST file to a backup name.
> - Rename the backup HOST file (without the gds entry in it)
to HOST.
> This prevents anyone from logging in
> once we start IB/FB.
> - Restart the IB/FB service with a "Net Start service" call
> - Call (invoke) gbak and backup the database
> - Lot's of other stuff done here, for error checking
and
> things...
> - .......
> - .......
> - Stop the IB/FB service again via the "Net Stop service" call
> - Rename to HOST file back to the non-gds containing backup
> - Rename the original HOST file (with the gds entry) to HOST
> - Start the IB/FB service via the "Net Start service" call
>
> Everyone's happy now. Backup's done (and checked in our case, but
that's up
> to you to do if you wish). No one was logged on during the gbak
procedure.
>
> Best regards,
> Fred Wilson
> SE, Bell & Howell
> fred.wilson@b...
>
>
>
> -----Original Message-----
> From: Artur Anjos [mailto:arsoft@n...]
> Sent: Tuesday, July 23, 2002 11:26 AM
> To: ib-support@y...
> Subject: Re: [ib-support] force disconnect users
>
>
> You can shutdown Firebird/Interbase.
>
> Or you can use GBak first to produce a GBK file, and backup on tape
that
> file.
>
> Artur
>
>
> ----- Original Message -----
> From: "Roger Pullen" <pullen.roger@v...>
> To: <ib-support@y...>
> Sent: Tuesday, July 23, 2002 6:01 PM
> Subject: [ib-support] force disconnect users
>
>
> > Hi all
> >
> > What is the best way of automatically ensuring all users
> > are logged out at, say, midnight, so that
> > the tape backup will work
> >
> > W2K server & IB6
> >
> > (There should not be any users in at this
> > time but there is always one who forgets
> > to switch their PC off)
> >
> > RogerP
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@e...
> >
> >
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
> >
> >
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@e...
>
>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/