# This batch file was created for an operation on host SQL01P using
# the SQL Server instance <default>.
# Move this file to the Veritas\NetBackup\dbext\MSSQL\ directory
# on host <SQL01P>. Execute it there using the NetBackup
# Database Extension GUI or the NetBackup Scheduler.
# 
#  This is a template for the database MOVE command.
#  
OPERATION RESTORE
OBJECTTYPE DATABASE
RESTORETYPE MOVE
#  
#  Replace the database name in the following line with the name of the database that you
#  want to move to. Also remove the hash mark <#> which precedes the keyword <DATABASE>.
#  
DATABASE "SP_**********"
# 
#  Replace the file path <S:\INST01\Data\MSSQL11.MSSQLSERVER\MSSQL\Data\SP_*******.mdf>
#  with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
#  The target of the MOVE keyword must be "SP_*************". 
MOVE  "SP_**********"
TO  "S:\INST01\Data\***********.mdf"
# 
# 
#  Replace the file path <S:\INST01\Log\MSSQL11.MSSQLSERVER\MSSQL\Data\SP_***********_log.ldf>
#  with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
#  The target of the MOVE keyword must be "SP_***********_log". 
MOVE  "SP_**********_log"
TO  "S:\INST01\Log\SP_D************_log.ldf"
# 
# The following image is type: Full
NBIMAGE "SQLCLS02P.yvw.com.au:SQL07P/MSSQL7/SQLAG02P/db/SP_**************/~/7/001of001/20210606084028//C"
SQLHOST "SQL01P"
NBSERVER "YVWNBUCLU1P.YVW.COM.AU"
BROWSECLIENT "SQLCLS02P"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE NOTRECOVERED
NUMBUFS 2
ENDOPER TRUE

ERR - Unable to determine fci cluster name for MSSQLSERVER
INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\SP_***************_restore.bch>: 
<0> operations succeeded. <1> operations failed.