restore database to another host

Have a look at NBU7 SQL Agent manual:

p.97: Redirecting a restore to a different host

check the below article

https://www-secure.symantec.com/connect/articles/how-backup-and-restore-microsoft-sql-server-backup-netbackup

@Marianne van den Berg:
@varunprakash :
Thanks, i've tried as yours suggestion but cannot restore, the operation status : error(-1)



Process as below

#  
#  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 "Test_restore"
#
#  Replace the file path <..............\Test_restore.mdf>
#  with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
#  The target of the MOVE keyword must be "Test_restore".
MOVE  "Test_restore"
#TO  "...............\Test_restore.mdf"
#
#
#  Replace the file path <.....................................\Test_restore_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 "Test_restore_log".
MOVE  "Test_restore_log"
#TO  "......................\Test_restore_log.ldf"
#
# The following image is type: Full
NBIMAGE "servername.MSSQL7.servername.db.Test_restore.~.7.001of001.20100820133218..C"
SQLHOST ".........."
NBSERVER "..........."
BROWSECLIENT "................"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE

USER - ?
INF - Results of executing <.........................\test restore.bch>:
<0> operations succeeded. <1> operations failed.
INF - The following object(s) were not backed up successfully.
INF - ?



Pru.vn

Try the following TN. If it doesnt work paste the bptm and bpcd logs for further investigation.

 

http://seer.entsupport.symantec.com/docs/311524.htm

U can also try the following TN

http://seer.entsupport.symantec.com/docs/244048.htm

@varunprakash : Thanks
I've tried but there are errors, and on activity monitor, could not found any restore database job.
If you have any document or link instruction restore database, Could you pls give me for clearly ?
Thanks

The Log file as below

# This batch file was created for an operation on host SMSSDBS01 using
# the SQL Server instance <default>.
# Move this file to the Veritas\NetBackup\dbext\MSSQL\ directory
# on host <........>. 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 "test_restore"
#
#  Replace the file path <C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\test_restore.mdf>
#  with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
#  The target of the MOVE keyword must be "test_restore".
MOVE  "test_restore"
TO  "D:\New Folder\test_restore.mdf"
#
#
#  Replace the file path <C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\test_restore_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 "test_restore_log".
MOVE  "test_restore_log"
TO  "D:\New Folder\test_restore_log.ldf"
#
# The following image is type: Full
NBIMAGE "..........MSSQL7.................db.test_restore.~.7.001of001.20100823094758..C"
SQLHOST ".............."
NBSERVER "..............."
BROWSECLIENT "............"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE

INF - RESTORE STARTED USING
Microsoft SQL Server 2005 - 9.00.4028.00 (Intel X86)
Oct 20 2008 19:45:04
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 6.0 (Build 6001: Service Pack 1)
Batch = C:\Users\............\Desktop\new test.bch, Op# = 1.
INF - Using backup image ..........4.MSSQL7..............4.db.test_restore.~.7.001of001.20100823094758..C
INF - restore database "test_restore" from VIRTUAL_DEVICE='VNBU0-7096-9128-1282534729' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'test_restore' to 'D:\New Folder\test_restore.mdf', move 'test_restore_log' to 'D:\New Folder\test_restore_log.ldf', replace
INF - Number of stripes: 1, Number of buffers per stripe 2.
ERR - Error in CoCreateInstance: 0x80040154.
    CONTINUATION: - An attempt was made to reference a token that does not exist.
INF - OPERATION #1 of batch C:\Users\...............\Desktop\new test.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 3(3) seconds.
INF - Results of executing <C:\Users\..............\Desktop\new test.bch>:
<0> operations succeeded. <1> operations failed.

http://seer.entsupport.symantec.com/docs/273567.htm

http://seer.entsupport.symantec.com/docs/267209.htm
http://seer.entsupport.symantec.com/docs/275780.htm

ERR - Error in CoCreateInstance: 0x80040154.
    CONTINUATION: - An attempt was made to reference a token that does not exist.

See :
http://seer.entsupport.symantec.com/docs/272407.htm
http://seer.entsupport.symantec.com/docs/283790.htm

Please ensure that you have dbclient log dir on destination client.

You try this article. it may help U

https://www-secure.symantec.com/connect/articles/how-backup-and-restore-microsoft-sql-server-backup-netbackup

Thanks all for your guides, But all posts are related to "Perform a database move" (create move template), which have to edit script.

We are interested in "Redirect a restore to a remote host". (We also surprise that there is not much topic about redirecting restore, in other hand, many topics are talking about create template move to achieve the goal to restore DB to another host). We have configure:

1. Add a blank file at : F:\Netbackup_System\db\altnames (we redirect catalog images to this folder other than the system partition), file name: No.Restrictions

2. Add host A as a server in Properties of host B [in Host Properties --> Clients]

our issue's symtom is exactly the same a the issue in the following link:
https://www-secure.symantec.com/connect/forums/sql-server-2005-restore-fails

But in our environment, We do not have any miss-match in NBU version, all are 7.0.

NBU server: Windows 2008 R2, catalog images redirected to different drive other than system drive C.
SQL server: Windows 2008 x64 with NBU 7 client agent.

Here are the logs: