SQL Restore

[H_Sharma]

Hello Experts,

We are restoring database from HostA(Source) to HostB(Destination) with create a move template.
Below is the script details. I logged on host B and mentioned hostA in the
SQL Host and Instace name (Anything) in the Source Client.

So I need to know in Backup Restoration script (that is on destination HostB) what will be in SQL host and browse client
Host A OR Host B?

Netbackup 7.6

# The following image is type: Full
NBIMAGE "HostA.MSSQL7.001of001.20160501034251..C"
SQLHOST "HOST"  ?????????
SQLINSTANCE "Anything"
NBSERVER "BCKMASTER"
BROWSECLIENT "HOST" ??????
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE

Please help?

[Carlo_Palmieri]

BROWSECLIENT = HostB

SQLHOST = HostB  if you run the script on the destination client

Syntax: 

https://www.veritas.com/support/en_US/article.000071054

IF you run the script from HOSTB (destination): 

NBIMAGE "HostA.MSSQL7.001of001.20160501034251..C"
SQLHOST "HostB"
SQLINSTANCE "Istance you want to restore to on HostB"
NBSERVER "BCKMASTER"
BROWSECLIENT "HostB"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE

Regards

Carlo

[Michal_Mikulik1]

You can use NetBackup MS SQL Agent interface on HostB to browse HostA backups (cross-client restores must be allowed on the Master) and it creates script for you.

Actually, "move template" script is required only when database name and/or datafile location changes. It is no necassary when destination server is different and db name/files remain the same.

Rgds

Michal