18 lines
1.4 KiB
Batchfile
18 lines
1.4 KiB
Batchfile
rem sqlcmd -U sa -P r3ds0x -S VOLIAN -Q "Backup database [VEPROMS_JCB1] to disk = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\VEPROMS_JCB1_%date:~10,4%%date:~4,2%%date:~7,2%_%time:~0,2%%time:~3,2%%time:~6,2%.BAK'"
|
|
rem ping 1.1.1.1 -n 1 -w 2000 > NUL
|
|
rem sqlcmd -U sa -P r3ds0x -S VOLIAN -Q "restore database [VEPROMS_JCB1] from disk = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\VEPROMS_JCB1_20110708_113115.BAK'"
|
|
rem if errorlevel 1 pause
|
|
rem sqlcmd -U sa -P r3ds0x -S VOLIAN -Q "restore database [VEPROMS_JCB1] from disk = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\VEPROMS_JCB1.BAK'"
|
|
rem if errorlevel 1 pause
|
|
rem ping 1.0.0.0 -n 1 -w 2000 > NUL
|
|
rem sqlcmd -U sa -P r3ds0x -S VOLIAN -d VEPROMS_JCB1 -i "C:\Development\Proms\SQL\PROMS2010_jcb.SQL"
|
|
rem ping 1.0.0.0 -n 1 -w 2000 > NUL
|
|
rem sqlcmd -U sa -P r3ds0x -S VOLIAN -d VEPROMS_JCB1 -i "C:\Development\Proms\SQL\jcbAuditConfig.sql"
|
|
rem ping 1.0.0.0 -n 1 -w 2000 > NUL
|
|
rem sqlcmd -U sa -P r3ds0x -S VOLIAN -d VEPROMS_JCB1 -i "C:\Development\Proms\SQL\tableToAuditConfig.sql"
|
|
rem ping 1.0.0.0 -n 1 -w 2000 > NUL
|
|
rem sqlcmd -U sa -P r3ds0x -S VOLIAN -d VEPROMS_JCB1 -i "C:\Development\Proms\SQL\jcbAuditConfigProcs.sql"
|
|
rem ping 1.0.0.0 -n 1 -w 5000 > NUL
|
|
sqlcmd -U sa -P r3ds0x -S VOLIAN -Q "restore database [VEPROMS_WCNEMG_CM] from disk = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\VEPROMS_WCNEMG_CM_18Aug2011.bak'"
|
|
if errorlevel 1 pause
|