Veritas Netbackup (SQL Server Agent) restore failing

[jpotucek]

I am running Veritas Netbackup\Netbackup MS SQL Client Version 7.0

the task at hand is to tape a recent backup of the CR_Reporting Database on SQL server KOCSQL01\Towerprod and restore it to Database CR_Reporting on SQL Server KOCSQLLAB02\TOWERTEST.


I created this restore script for Database CR_Reporting on SQL Server KOCSQL01 using the move template option from the restore menu.

I changed the 'MOVE' and 'TO' lines to reflect the Destination locations for the Data and log files and then I changed these lines:

changed SQLHOST "KOCSQL01" to SQLHOST "KOCSQLLAB02"
changed SQLINSTANCE "TOWERPROD" to SQLINSTANCE "TOWERTEST"
changed BROWSECLIENT "KOCSQL01" to BROWSECLIENT "KOCSQLLAB02"

Here is my final script:
OPERATION RESTORE
OBJECTTYPE DATABASE
RESTORETYPE MOVE
DATABASE "CR_Reporting"
MOVE "CR_Reporting_Data"
TO "E:\CR_Reporting_Data.MDF"
MOVE "CR_Reporting_Log"
TO "E:\CR_Reporting_Log.LDF"
NBIMAGE "kocsql01.MSSQL7.KOCSQL01\TOWERPROD.db.CR_Reporting.~.7.001of001.20110802074658..C"
SQLHOST "KOCSQLLAB02"
SQLINSTANCE "TOWERTEST"
NBSERVER "KOCBKUP02"
BROWSECLIENT "KOCSQLLAB02"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE

When I run the script, I get this error:

INF - RESTORE STARTED USING
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\Restore_CR_Reporting.bch, Op# = 1.
INF - Using backup image kocsql01.MSSQL7.KOCSQL01\TOWERPROD.db.CR_Reporting.~.7.001of001.20110802074658..C
INF - restore database "CR_Reporting" from VIRTUAL_DEVICE='VNBU0-2340-5000-1312286979' with blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'CR_Reporting_Data' to 'E:\CR_Reporting_Data.MDF', move 'CR_Reporting_Log' to 'E:\CR_Reporting_Log.LDF', replace
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <TOWERTEST>. Connection timeout is <300> seconds.
ERR - Error in VxBSAQueryObject: 17.
CONTINUATION: - No object matched the specified predicate.

Can anyone help me figure out what I am doing wrong?

 

[chana22]

Currently is there an existing DB in KOCSQLLAB02\TOWERTEST?
If so does NBU have access to the server/db?
If not have your dba create the TOWERTEST db within KOCSQLLAB02 and grant it appropriate access and try again...