Consultor Eletrônico

Status: Unverified

FACT(s) (Environment):

Progress 9.x

SYMPTOM(s):

Error 276 backing up database from a batch file after running DBMAN -STOP -ALL

** The database <file-name> is in use in multi-user mode. (276)

Batch file runs DBMAN -STOP -ALL, followed by PROBKUP statements, and ending with DBMAN -START -ALL

DBMAN -STOP -ALL used to shut down multiple databases

DBMAN successfully shuts down all databases when issued from a command line

Using standard PROBKUP command to backup each database

CAUSE:

PROBKUP is executing before all of the database processes (_mprosrv.exe and _mprshut.exe) have been closed down by DBMAN. Therefore, according to PROBKUP, the database is still in use.

FIX:

To avoid the problem, the execution of the batch file needs to be slowed. This can be achieved in 2 ways.

Method #1:
Split the batch file up into different parts, each part issuing a different command and schedule each batch file to run a few minutes apart:

00:00 - batch #1 issues the DBMAN -STOP -ALL command
00:05 - batch #2 issues the PROBKUP commands
00:10 - batch #3 issues the DBMAN -START -ALL command


Method #2:
Add the following command after DBMAN -STOP -ALL to delay the execution of PROBKUP:

PING 127.0.0.1 -n 30 > NUL

Raise or lower the -n parameter to increase or decrease the delay period giving sufficient time for all database processes to shut down. Using this method, only 1 batch file needs to be maintained.