PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → start/stop hfsql server
start/stop hfsql server
Iniciado por guest, 08,feb. 2018 12:05 - 2 respuestas
Publicado el 08,febrero 2018 - 12:05
Hi,

to get a consistent backup I want to stop the hfsql service at the start of the backup. And start it again afterwards.

I can do that using a NET STOP hfsql-service-name. Does anyone know if that shuts down the service in a clean way. I mean if the hfsql service has some data in cache will that be written at that time?
I also can write a smapp utility using the HStopServer() and HStartServer() functions if that would be better.

In the past I did a backup without shutting down the hfsql-service. Just copying the (in-use) files on the file system level. This resulted at least one time in a large MMO file being incomplete. So I'm looking for a 100% reliable backup.

I also know the hfsql can do a backup. But this is very slooow, looks like it does this record-by-record, instead of going in some state of backup-mode like sqlserver and Oracle to be avble to do a file-copy
Publicado el 08,febrero 2018 - 12:45
Hi,

Looks like it does things cleanly?

NET STOP service NET STOP stops Windows services. Stopping a service cancels any network connections the service is using. Also, some services are dependent on others. Stopping one service can stop others. Some services cannot be stopped. service May be one of the following services: BROWSER DHCP CLIENT FILE REPLICATION NETLOGON REMOTE ACCESS CONNECTION MANAGER ROUTING AND REMOTE ACCESS SCHEDULE SERVER SPOOLER TCP/IP NETBIOS HELPER UPS WORKSTATION NET STOP can also stop services not provided with Windows. NET HELP command | MORE displays Help one screen at a time.
Publicado el 08,febrero 2018 - 14:09
For services (creation, deletion, configuration, querying) I tend to use the SC command...
Check SC /? at the command line to see all options.

Cheers,

Peter H.