Peter,

> 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

This is nasty - you're killing the process.

> 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?

What should this script do?

Did you know you can block access by shutting down a database?

Why create a backup with "gbak"?

With regards,

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