Backup Online

Boa tarde pessoal,

Estou tendo um problema aqui na empresa e gostaria de saber se alguem pode me ajudar, trata-se que temos um script de backup on line aqui, mas quando ele é executado a memoria do meu servidor vai até consumir tudo, tipo assim num estado normal os bancos do datasul ficam carregados num total de 5 GB quando começa a realizar o backup on line a memoria vai para 11,8 e o servidor só tem 12GB quando termina o backup on line ele nao diminui fica com esse consumo armazenado e ele so abaixa se eu derrubar o banco, ou por incrivel que pareça se eu fizer um restore destes bancos ele tambem diminui, alguem ja viu isto ?

Segue abaixo os scripts de backup on line e restore

Código:

#### BACKUP ON LINE ###########

@ECHO OFF
:############################################################################
:# Arquivo...............: ProgressBackupOnline.bat
:# Descrição.............: Backup de Bancos de Dados Progress
:############################################################################

SET LOG=.\ProgressBackupOnline.log
IF EXIST %LOG% DEL %LOG%
ECHO Backup dos Bancos Progress - Base Oficial >> %LOG%

SET MAILFROM=diego@stamaria.ind.br
SET MAILTO=diego@stamaria.ind.br
SET SMTP=mail.stamaria.ind.br
SET BLAT=.\Blat.exe
SET DLC=D:\DATASUL\DLC101A
SET BKP=D:\Datasul\Backup_Online
SET SUBJECT=Backup efetuado com sucesso
SET CHKERRO=IF ERRORLEVEL 1 CALL :ERRO

IF "%1%" == "-auto" GOTO EXECUTA
SET SUBJECT=***BACKUP NAO EFETUADO***
ECHO *** Sintaxe: ProgressBackupOnline.bat -auto >> %LOG%
GOTO EMAIL

:EXECUTA 
:############################################################################
:# Apaga backup anterior
:############################################################################
Echo Apagando backup anterior... >> %LOG%
DEL /Q %BKP%\*.* 2>> %LOG%
%CHKERRO%

:############################################################################
:# Efetua backups dos bancos 
:############################################################################

:# Banco EMS2CAD 
SET BANCO=EMS2CAD
SET CAMINHO=D:\DATASUL\EMS204\Database
echo Copiando %BANCO%... >> %LOG%
%CHKERRO%
CALL %DLC%\BIN\PROBKUP ONLINE %CAMINHO%\%BANCO% %BKP%\%BANCO%.PRB -red 10 -com

:# Banco EMS2MUL 
SET BANCO=EMS2MUL
SET CAMINHO=D:\DATASUL\EMS204\Database
echo Copiando %BANCO%... >> %LOG%
%CHKERRO%
CALL %DLC%\BIN\PROBKUP ONLINE %CAMINHO%\%BANCO% %BKP%\%BANCO%.PRB -red 10 -com

:# Banco EMS2SMA1
SET BANCO=EMS2SMA1
SET CAMINHO=D:\DATASUL\EMS204\Database
echo Copiando %BANCO%... >> %LOG%
%CHKERRO%
CALL %DLC%\BIN\PROBKUP ONLINE %CAMINHO%\%BANCO% %BKP%\%BANCO%.PRB -red 10 -com

:# Banco EMS2DES
SET BANCO=EMS2DES
SET CAMINHO=D:\DATASUL\EMS204\Database
echo Copiando %BANCO%... >> %LOG%
%CHKERRO%
CALL %DLC%\BIN\PROBKUP ONLINE %CAMINHO%\%BANCO% %BKP%\%BANCO%.PRB -red 10 -com

:# Banco EMSWEB
SET BANCO=EMSWEB
SET CAMINHO=D:\DATASUL\EMS204\Database
echo Copiando %BANCO%... >> %LOG%
%CHKERRO%
CALL %DLC%\BIN\PROBKUP ONLINE %CAMINHO%\%BANCO% %BKP%\%BANCO%.PRB -red 10 -com

:# Banco HCM209 #
SET BANCO=HCM209
SET CAMINHO=D:\DATASUL\HCM209\Database
echo Copiando %BANCO%... >> %LOG%
%CHKERRO%
CALL %DLC%\BIN\PROBKUP ONLINE %CAMINHO%\%BANCO% %BKP%\%BANCO%.PRB -red 10 -com

:# Banco EMS505
SET BANCO=EMS5
SET CAMINHO=D:\DATASUL\EMS505\Database
echo Copiando %BANCO%... >> %LOG%
%CHKERRO%
CALL %DLC%\BIN\PROBKUP ONLINE %CAMINHO%\%BANCO% %BKP%\%BANCO%.PRB -red 10 -com

:############################################################################
:# Envia e-mail de Logs
:############################################################################

:EMAIL
%BLAT% %LOG% -server %SMTP% -mailfrom %MAILFROM% -to %MAILTO% -subject "%SUBJECT%"
EXIT /B

:ERRO
ECHO *** Erro na operação ***
SET SUBJECT=***BACKUP EFETUADO COM ERRO***



########### RESTORE DO BACKUP ON LINE #####################


@ECHO OFF
:############################################################################
:# Arquivo...............: ProgressRestore.bat
:# Descrição.............: Restaura Bancos de Dados Progress
:############################################################################

SET LOG=.\ProgressRestore%1%.log
IF EXIST %LOG% DEL %LOG%
ECHO Restauracao dos Bancos Progress >> %LOG%

SET MAILFROM=diego@stamaria.ind.br
SET MAILTO=diego@stamaria.ind.br
SET SMTP=mail.stamaria.ind.br
SET BLAT=.\Blat.exe
SET DLC=D:\DATASUL\DLC101A
SET BANCO=%1%
SET BKP=%2%
SET SUBJECT=Restauracao efetuada com sucesso
SET CHKERRO=IF ERRORLEVEL 1 SET SUBJECT=***RESTAURACAO EFETUADA COM ERRO***

IF "%BKP%" == "" GOTO ERRO_PARAMETRO
GOTO EXECUTA
:ERRO_PARAMETRO
SET SUBJECT=***RESTAURACAO NAO EFETUADA***
ECHO *** Sintaxe: ProgressRestore.bat {nome do banco} {diretorio do backup} >> %LOG%
GOTO LISTA_LOG


:EXECUTA 
:############################################################################
:# Verifica existencia de arquivo .st e .db no destino
:############################################################################
IF EXIST %BANCO%.ST GOTO VERIFICA_DB
SET SUBJECT=***RESTAURACAO NAO EFETUADA***
ECHO *** Arquivo %BANCO%.ST nao existe >> %LOG%
GOTO LISTA_LOG

:VERIFICA_DB
IF NOT EXIST %BANCO%.DB GOTO RESTAURA
SET SUBJECT=***RESTAURACAO NAO EFETUADA***
ECHO *** Arquivo %BANCO%.DB ja existe >> %LOG%
GOTO LISTA_LOG

:############################################################################
:# Restaura Banco
:############################################################################
:RESTAURA
echo Copiando %BANCO%... >> %LOG%

%DLC%\BIN\_DBUTIL PROREST %BANCO% %BKP%\%BANCO%.PRB >> %LOG%
%CHKERRO%

:############################################################################
:# Lista Logs
:############################################################################
:LISTA_LOG
TYPE %LOG%

Ola Marcos, tenho sim

OS: Windows Server 2008 64 bits
Progress: Opendege101a com SP e fix atualizados

Hardware: Dell Power Edge
2 Processadores Intel Xeon Quad Core 1.6 Ghz
12 GB Memoria
3 HDs SAS 146 GB RAID 5

Att.

Diego

Ok marcos, mas so coloco este parametro no final dos bancos sem valor algum ?

Diego