sybase_mydb_restore.cmd script example for NetBackup

The following code example shows the sybase_mydb_restore.cmd script:

The sybase_mydb_restore script is as follows:

@setlocal 
@echo off 
  
@REM **************************************************************************
@REM Replace C:\Sybase below with your actual Sybase home directory 
@REM **************************************************************************
@set SYBASE=C:\Sybase
  
@REM **************************************************************************
@REM Replace SYBASE below with the actual name of your SQL Server
@REM **************************************************************************
@set SYBSERVER=SYBASE
  
if "%SYBASE_OCS%" == "" goto notsyb12
@REM ********* Sybase 12.0 or later ***********
@set OCS_QUAL=\%SYBASE_OCS%
goto cont1
  
:notsyb12
@REM ********* Sybase 11.9.2 or earlier **********
@set OCS_QUAL=
  
:cont1
  
@REM **************************************************************************
@REM Replace ".\sybase_mydb_load" below with a full directory path only if
@REM the script file which contains the isql LOAD command is in a different
@REM directory than this script file.
@REM **************************************************************************
@set LOADDB=".\sybase_mydb_load"
  
@REM NetBackup has started a restore
@REM **************************************************************************
@REM Replace "manager" with your Sybase server Administrator's Password
@REM **************************************************************************
set CMD_LINE=%SYBASE%%OCS_QUAL%\bin\isql -Usa -Pmanager -I%SYBASE%\ini\sql.ini 
-S%SYBSERVER% -i %LOADDB%
  
  
  
@echo %CMD_LINE%
%CMD_LINE%
  
  
@echo on
@endlocal