It’s not a batch file for a backup, but only to stop the appserver and then
to restart them.. So you have to put your files between them.
*Amélie Pelletier*
*Analyste Programmeur / Program analyst*
[image: cid:image001.jpg@01CD5525.2091A820]
*230, Boulevard Nilus-Leclerc*
*L'Islet, Québec (Canada)*
*G0R 2C0*
*Téléphone: 418-247-3986 ext. 2402*
*Fax: 418-247-7925*
*
amelie.pelletier@... <
brigitte.savoie@...>*
*P* Est-ce nécessaire d’imprimer ce message?
*Please consider the environment before printing this email**.*
*De :*
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com]
*Envoyé :* 2 février 2015 16:52
*À :*
vantage@yahoogroups.com
*Objet :* RE: [Vantage] Self Service Test DB refresh
How do you change the 9401 to 9431?
Or is the backup already have 9431 in the system agent?
Miguel A. Santillan
*Compass Manufacturing Systems*
*From:*
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com
<
vantage@yahoogroups.com>]
*Sent:* Monday, February 2, 2015 1:36 PM
*To:*
vantage@yahoogroups.com
*Subject:* RE: [Vantage] Self Service Test DB refresh
By batch file to start the appserver :
@echo off
set DLC=E:\Epicor\OE102A
set PATH=%DLC%\BIN;%PATH%
set UserID=groupebertec\sqlsvradminbd
set AppServerEnv=Epicor905
set AppSrv1=epicor
set AppSrvPrt1=epicor
rem -user %UserID% -start < D:\Scripts\prcstr.txt
echo starting Database SchemaHolder...
rem call dbman -host %AppSrv1% -database %APPSERVERENV% -start
echo starting AppServer...
call asbman -host %AppSrv1% -name %APPSERVERENV%
-start
call asbman -host %AppSrvPrt1% -name %APPSERVERENV%Print
-start
call asbman -host %AppSrvPrt1% -name %APPSERVERENV%TaskAgent
-start
call asbman -host %AppSrvPrt1% -name %APPSERVERENV%ProcessServer
-start
rem Pause
By batch file to stop:
@echo off
set DLC=E:\Epicor\OE102A
set PATH=%DLC%\BIN;%PATH%
set UserID=groupebertec\sqlsvradminbd
set AppServerEnv=Epicor905
set AppSrv1=epicor
set AppSrvPrt1=epicor
rem -user %UserID% -start < D:\Scripts\prcstr.txt
echo starting AppServer...
call asbman -host %AppSrvPrt1% -name %APPSERVERENV%ProcessServer
-stop
call asbman -host %AppSrvPrt1% -name %APPSERVERENV%TaskAgent
-stop
call asbman -host %AppSrvPrt1% -name %APPSERVERENV%Print
-stop
call asbman -host %AppSrv1% -name %APPSERVERENV%
-stop
echo starting Database SchemaHolder...
rem call dbman -host %AppSrv1% -database %APPSERVERENV% -stop
rem Pause
*Amélie Pelletier*
*Analyste Programmeur / Program analyst*
[image: cid:image001.jpg@01CD5525.2091A820]
*230, Boulevard Nilus-Leclerc*
*L'Islet, Québec (Canada)*
*G0R 2C0*
*Téléphone: 418-247-3986 ext. 2402*
*Fax: 418-247-7925*
*
amelie.pelletier@... <
brigitte.savoie@...>*
*P* Est-ce nécessaire d’imprimer ce message?
*Please consider the environment before printing this email**.*
*De :*
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com
<
vantage@yahoogroups.com>]
*Envoyé :* 2 février 2015 16:25
*À :*
vantage@yahoogroups.com
*Objet :* [Vantage] Self Service Test DB refresh
I am being asked to allow a user to refresh the test database from a backup
of the production db on his own when ever he needs to. Tried talking people
out of it but we all know how that goes.
I have a batch file that will delete the files out of the db\test and then
restore the db from the backup location. I'm wondering if there are ways to
have the bat file stop the test app servers and DB, and then restart the DB
and App servers.
I'm trying to keep the user out of the Progress Explorer tool if at all
possible. I know he will have to be able to go in and change ports in the
system agent.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]