Forum Discussion

H_Sharma's avatar
H_Sharma
Level 6
9 years ago

SQL Restore

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?

7.6
Backup and Recovery
NetBackup
Restore
Windows Server (2003-2008)

2 Replies

Sort By
  • Carlo_Palmieri's avatar
    Carlo_Palmieri
    Level 3
    9 years ago

    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's avatar
    Michal_Mikulik1
    Moderator
    9 years ago

    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