| Subject | RE: [ib-support] force disconnect users |
|---|---|
| Author | Wilson, Fred |
| Post date | 2002-07-23T20:06:21Z |
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@...
-----Original Message-----
From: Artur Anjos [mailto:arsoft@...]
Sent: Tuesday, July 23, 2002 11:26 AM
To: ib-support@yahoogroups.com
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
- 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@...
-----Original Message-----
From: Artur Anjos [mailto:arsoft@...]
Sent: Tuesday, July 23, 2002 11:26 AM
To: ib-support@yahoogroups.com
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@...>
To: <ib-support@yahoogroups.com>
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@egroups.com
>
>
>
> 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@egroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/