Introduction

Exact Financials uses AppServers, this is a point of attention when considering the back up scenario. Before using an AppServer the database was often simply brought offline in the night, files copied to backup media and then the database was brought back up again. The AppServers have a permanent connection to the database and therefore also need to be reckoned with in the back up scripts.

Database

A database can be controlled using the following scripts:

Stop database

SET DLC=c:\progress
CALL %DLC%\dbman -db db70exact -stop

Note that command script processing continues directly after the stop has been issued, the database has not necessarily stopped yet.

Start database

SET DLC=c:\progress
CALL %DLC%\dbman -db db70exact -start

AppServers

An AppServer can be controlled using the following scripts:

Stop AppServer

SET DLC=c:\progress
CALL %DLC%\asbman -i as70exact -stop

Note that if an AppServer does not respond within a reasonable amount of time, a kill should be issued.

Kill AppServer

SET DLC=c:\progress
CALL %DLC%\asbman -i as70exact -kill

Start AppServer

SET DLC=c:\progress
CALL %DLC%\asbman -i as70exact -start

Back up

A traditional back up script will stop the database, copy the files to a safe location / offline media and then restart the database. Stopping the database is not necessary since an online backup can easily be made using:

SET DLC=c:\progress
CALL %DLC%\bin\probkup online exact.db backup\exact.bu

The exact.bu file can then be copied to a safe location / offline media

A backup can be restored using:

SET DLC=c:\progress
CALL %DLC%\bin\prorest exact.db backup\exact.bu