Subject RE: [ib-support] force disconnect users
Author Wilson, Fred
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"
- 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
- .......
- .......
- 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

-----Original Message-----
From: Artur Anjos [mailto:arsoft@...]
Sent: Tuesday, July 23, 2002 11:26 AM
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


----- Original Message -----
From: "Roger Pullen" <pullen.roger@...>
To: <>
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
> To unsubscribe from this group, send an email to:
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to