V8 - Batch restore

I have one that stops the DB, as well as ends AI if you happen to be
using it,

copies the DB and copies the after image files and then restarts
everything.





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Anderson
Sent: Tuesday, March 13, 2007 5:49 PM
To: 'Vantage @ YahooGroups. Com'
Subject: [Vantage] V8 - Batch restore



Does anyone have a BAT file that will:

Stop a V8 database
Restore from backup
Restart the database

???

Thanks,

Todd Anderson





[Non-text portions of this message have been removed]
Does anyone have a BAT file that will:

Stop a V8 database
Restore from backup
Restart the database

???

Thanks,

Todd Anderson
@echo off
echo Stopping 8.0 Services and Database...

set DLC=c:\Epicor\OE100B
set PATH=%DLC%\BIN;%PATH%
set LIB=%DLC%\LIB;%LIB%

C:

echo .
echo .

echo STOPPING MfgSys80 DB/APPSERVER...
cd \Epicor\MfgSys80\db
call asbman -name MfgSys80ProcessServer -stop
call asbman -name MfgSys80TaskAgent -stop
call asbman -name MfgSys80 -stop
call dbman -host localhost -port 20931 -database Mfgsys80 -stop

c:
cd c:\epicor\mfgsys80\db
c:\epicor\oe100b\bin\prorest mfgsys <path to backup file>


c:

echo.
echo.

echo STARTING MfgSys80 DB/APPSERVER...
cd \Epicor\MfgSys80\db
call dbman -host localhost -port 20931 -database Mfgsys80 -start
call asbman -name MfgSys80 -start
call asbman -name MfgSys80TaskAgent -start
call asbman -name MfgSys80ProcessServer -start


maybe?

--- In vantage@yahoogroups.com, "Todd Anderson" <todd.anderson@...>
wrote:
>
> Does anyone have a BAT file that will:
>
> Stop a V8 database
> Restore from backup
> Restart the database
>
> ???
>
> Thanks,
>
> Todd Anderson
>