> But, you should consider if you have to stop server:
> - Shutdown Database to kick out other Users

Could you tell me how to do this?

Peter Ypenburg.


From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Elmar Haneke
Sent: Thursday, May 19, 2005 4:04 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Can I corrupt a database by just
stoppingfirebird guardian while many processes are running.

> REM *** removes the fb_inet_server process from the task manager
> pskill fb_inet_server.exe

This should not be done in the first step. If regular shutdown fails
it might be an option to kill the disfunctional process.

> REM *** Stops the Firebird Services for database renaming purposes ***
> NET STOP "Firebird server - defaultinstance"
> NET STOP "Firebird guardian - defaultinstance"

You should only stop Guardian since this does also control Server. If
you only stop Server Guardian will restart it. I'ts not causing harm
but unnecessary workload.

> 1.) Just killing fb_inet_server.exe processes could caused data

corruptions.

There is some risk in doing so

> 2.) To stop firebird it is only the guardian that needs to be stopped not
> the server as when guardian is stopped then the server will be stopped as
> well.
> 3.) To start firebird the same as point 2 applies.

Starting/Stopping Guardian should be ok.

> 4.) Are the command lines to stop and start firebird OK or should it be

done

> differently?

It is that simple, there is nothing to be changed to start/stop Server.

But, you should consider if you have to stop server:

- Shutdown Database to kick out other Users
- Drop database to delete file
- be shure noone is connected to Client1.gdb
- Rename Client1.gdb to Client.gdb

This should work without stopping the server.

Elmar


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links