The following code is in a bat file written by someone and I am concerned
about the impact it will have on our database:
***********Bat file code start***************

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

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

REM *** Renaming of restore file ***
IF EXIST "\Optimiza\Data\Client1.gdb" DEL "\Optimiza\Data\Client.gdb"
IF EXIST "\Optimiza\Data\Client1.gdb" REN "\Optimiza\Data\Client1.gdb"
Client.gdb
IF EXIST "\Optimiza\Data\Client.gdb" DEL "\Optimiza\Data\Client1.gdb"

REM *** Restarts the Firebird Services ***
NET START "Firebird server - defaultinstance"
NET START "Firebird guardian - defaultinstance"

***********Bat file code end*****************

Could some one confirm my concerns and the are as follows:
1.) Just killing fb_inet_server.exe processes could caused data corruptions.
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.
4.) Are the command lines to stop and start firebird OK or should it be done
differently?

Thank you.

Peter Ypenburg


From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Martijn Tonies
Sent: Thursday, May 19, 2005 9:41 AM

Hi,

> If there are several users connected to a firebird server, and someone
> decides to stop firebird guardian on the server, can this corrupt a
> database?

The server should down "properly" in this case, so no, it shouldn't
corrupt a database.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com



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

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