HP StorageWorks P9000 Replication Manager Software 7.1 CLI User Guide (TB584-96026, May 2011)

[POST_PROC]: Executes the remote_sqlrestore.bat batch file. The contents of
remote_sqlrestore.bat mount the secondary volume and execute the restore command with
the -no_resync specification and the recovery command.
• remote_sqlrestore.bat
@echo off
@drmmount –copy_group VG01,VOL11 –mount_pt F:
if NOT "%ERRORLEVEL%"=="0" GOTO ABEND
@drmmount –copy_group VG01,VOL12 –mount_pt G:
if NOT "%ERRORLEVEL%"=="0" GOTO ABEND
@drmsqlrestore %DRMENV_R_BACKUPID% -no_resync –nochk_host
–instance instB
if NOT "%ERRORLEVEL%"=="0" GOTO ABEND
@drmsqlrecover instB
if NOT "%ERRORLEVEL%"=="0" GOTO ABEND
GOTO END
:ABEND
exit 1
:END
exit 0
script2.txt (used for backup)
LOCAL_BACKUP=YES
#Post-backup user script section
[POST_PROC]
#Normal case
[CMD]
CMDLINE=C:\user\remote_tapebackup.bat
END_CODE=1
TIMEOUT=NOWAIT
LOCATION=REMOTE
PARENT_STAT=NORMAL
[PRE_PROC]: None
[POST_PROC]: Executes the remote_tapebackup.bat batch file. The contents of
remote_tapebackup.bat use the NetBackup command to back up the database on the secondary
volume to tape and unmount the secondary volume.
• remote_tapebackup.bat
Operation for SQL Server databases386