Forum Discussion

amdcler's avatar
amdcler
Level 4
10 years ago

How restore SQL database to different server?

Hello!
We used Netbackup 7.6.1
With scripts .bch has been configured Full online backup SQL database which succeeds. Recovery with .bch is also successful, but only on the same server. (in mode "recovered" and "not recovered" (.mdb,.ldb))

How to set up a database restore to a different server?
I have tried to make these instructions:

Recovery is initiated on the master server

Redirecting a SQL restore to a different host
Multiple NetBackup database clients can be configured to use a single NetBackup
master server for backing up SQL Server databases. With this configuration, you
can back up SQL Server database objects from one client and restore them to
another. In the following procedure, HostA is the client that was originally backed
up and HostB is the other client to which the restore is redirected.
To redirect a restore to a different host
1 Establish permission settings on the master server.
Do one of the following:
■ Create a install_path\NetBackup\db\altnames\No.Restrictions file
to allow unrestricted redirected restore privileges.
■ Create a install_path\NetBackup\db\altnames\HostB file to allow HostB
to restore HostA's data. The client named HostB can then access HostA's
data on the master as well as any other client's data that was backed up
on the master.
2 Select File > SetSQLServerconnectionproperties.
3 Log onto the target instance on HostB.
4 Select File > SetNetBackupclientpropertiesand select the current master
server to be a master server that is common to both HostA and HostB.
5 Select File > RestoreSQLServerobjects.
6 From the Backup History Options dialog box, select HostA as the SQL host
from which the target objects were backed up.
When the restore window appears it contains a history of objects that were
backed up from HostA. Select those objects and restore them to HostB.

In this scenario, I get an error

ERR - Error in CoCreateInstance: 0x80040154.

 

 

and Recovery is initiated on the client server which was backuped

https://support.symantec.com/en_US/article.TECH35995.html

Here is an example with the option "not recovered"

HostA - source client

HostB - destination client

# 
#  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 "123"
#
#  Replace the file path <E:\SQLData\PortalDBs\WSS_videocam.mdf>
#  with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
#  The target of the MOVE keyword must be "WSS_videocam".
MOVE  "WSS_videocam"
TO  "E:\123.mdf"
#
#
#  Replace the file path <E:\SQLData\PortalDBs\WSS_videocam_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 "WSS_videocam_log".
MOVE  "WSS_videocam_log"
TO  "E:\123_log.LDF"
#
# The following image is type: Full
NBIMAGE "HostA.MSSQL7.HOSTA.db.WSS_videocam.~.7.001of001.20150430110244..C"
SQLHOST "HostB"
NBSERVER "HostM"
BROWSECLIENT "HostA"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE NOTRECOVERED
SQLCOMPRESSION TRUE
NUMBUFS 2
ENDOPER TRUE

INF - RESTORE STARTED USING
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)
Jun 28 2012 08:36:30
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
Batch = C:\test.bch, Op# = 1.
INF - Using backup image HostA.MSSQL7.HOSTA.db.WSS_videocam.~.7.001of001.20150430110244..C
INF - restore database "123" from VIRTUAL_DEVICE='VNBU0-6740-6876-1430400456' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'WSS_videocam' to 'E:\123.mdf', move 'WSS_videocam_log' to 'E:\123_log.LDF', replace
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <HostB>. Connection timeout is <300> seconds.
ERR - Error in GetConfiguration: 0x80770003.
    CONTINUATION: - The api was waiting and the timeout interval had elapsed.
DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3201><[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'VNBU0-6740-6876-1430400456'. Operating system error 0x80070002(failed to retrieve text for this error. Reason: 15105).>.
DBMS MSG - SQL Message <3013><[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE is terminating abnormally.>
ERR - Error found executing <restore database "123" from VIRTUAL_DEVICE='VNBU0-6740-6876-1430400456' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'WSS_videocam' to 'E:\123.mdf', move 'WSS_videocam_log' to 'E:\123_log.LDF', replace>.
INF - OPERATION #1 of batch C:\test.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 304(304) seconds.
INF - Results of executing <C:\test.bch>:
<0> operations succeeded. <1> operations failed.

 

As now all I fix this? I already read a lot of topics on the forum and admin guide, but nothing happens...

Is it possible to perform a recovery exclusively on the master server in case the server is physically damaged power?

Thanks in advance.

Agent for Microsoft SQL Server
Backup and Recovery
NetBackup
Windows Server (2003-2008)
  • Marianne's avatar
    Marianne
    10 years ago
    You cannot initiate a SQL restore from the master server. You can only start the restore from the destination client. See 'Redirecting a SQL restore to a different host' in NetBackup for Microsoft SQL Server Administrator's Guide : http://www.symantec.com/docs/DOC6479

18 Replies

Sort By
Replies have been turned off for this discussion
  • Marianne's avatar
    Marianne
    Level 6
    10 years ago
    You cannot initiate a SQL restore from the master server. You can only start the restore from the destination client. See 'Redirecting a SQL restore to a different host' in NetBackup for Microsoft SQL Server Administrator's Guide : http://www.symantec.com/docs/DOC6479
  • amdcler's avatar
    amdcler
    Level 4
    10 years ago

    OK, I understand, here's how it looks:

    # 
    #  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 "videocam"
    #
    #  Replace the file path <E:\SQLData\PortalDBs\WSS_videocam.mdf>
    #  with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
    #  The target of the MOVE keyword must be "WSS_videocam".
    MOVE  "WSS_videocam"
    TO  "E:\Restored\videocam.mdf"
    #
    #
    #  Replace the file path <E:\SQLData\PortalDBs\WSS_videocam_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 "WSS_videocam_log".
    MOVE  "WSS_videocam_log"
    TO  "E:\Restored\videocam_log.LDF"
    #
    # The following image is type: Full
    NBIMAGE "HostA.MSSQL7.HostA.db.WSS_videocam.~.7.001of001.20150430110244..C"
    SQLHOST "HostB"
    NBSERVER "HostM"
    BROWSECLIENT "HostA"
    MAXTRANSFERSIZE 6
    BLOCKSIZE 7
    RESTOREOPTION REPLACE
    RECOVEREDSTATE NOTRECOVERED
    SQLCOMPRESSION TRUE
    NUMBUFS 2
    ENDOPER TRUE

    INF - RESTORE STARTED USING
    Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)
    Jun 28 2012 08:36:30
    Copyright (c) Microsoft Corporation
    Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
    Batch = C:\Users\administrator\Desktop\1234.bch, Op# = 1.
    INF - Using backup image HostA.MSSQL7.HostA.db.WSS_videocam.~.7.001of001.20150430110244..C
    INF - restore database "videocam" from VIRTUAL_DEVICE='VNBU0-2512-4124-1430404979' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'WSS_videocam' to 'E:\Restored\videocam.mdf', move 'WSS_videocam_log' to 'E:\Restored\videocam_log.LDF', replace
    INF - Number of stripes: 1, Number of buffers per stripe 2.
    INF - Created VDI object for SQL Server instance <HostB>. Connection timeout is <300> seconds.
    Restore started Thu Apr 30 17:43:00 2015

    ERR - Error in VxBSAGetMultipleObjects: 26.
        CONTINUATION: - There is no copy of the requested object.

    INF - OPERATION #1 of batch C:\Users\administrator\Desktop\1234.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 37(37) seconds.
    INF - Results of executing <C:\Users\administrator\Desktop\1234.bch>:
    <0> operations succeeded. <1> operations failed.

  • amdcler's avatar
    amdcler
    Level 4
    10 years ago

    Logs from the master server for this task

    30.04.2015 17:43:00 - Info dbclient(pid=2512) INF - Created VDI object for SQL Server instance <HostB>. Connection timeout is <300> seconds.

    30.04.2015 17:43:31 - Info dbclient(pid=2512) ERR - Error in VxBSAGetMultipleObjects: 26.

    30.04.2015 17:43:31 - Info dbclient(pid=2512) CONTINUATION: - There is no copy of the requested object.

  • Marianne's avatar
    Marianne
    Level 6
    10 years ago

    You cannot start the restore on the master server.

    Create dbclient log folder on the destination client, increase Client Read Timeout on the media server to 7200, then start the restore on the destination client.

    If restore fails again, copy dbclient log to dbclient.txt and upload as File attachment.

  • Pangal's avatar
    Pangal
    Level 5
    10 years ago


     

            Can you confirm whether the user your are using for restore has sysadmin privileges\ adminstrative user , also make sure that netbackup client and legacy service is running  with the same user.

     

  • amdcler's avatar
    amdcler
    Level 4
    10 years ago

    in the attachment dbclient log from HostB (destination SQL client)

    the user "nb_service" is sysadmin SQL database, and service "netbackup client" starts on his behalf

  • Marianne's avatar
    Marianne
    Level 6
    10 years ago

    The log shows comms problem with the master server :

    20:08:31.787 [2960.4260] <16> RestoreFileObjects: ERR - serverResponse() failed

    Before you try another restore, see if you can do a backup of default SQL db's on the destination client.

    Confirm forward and reverse name lookup between master and client and between media server and client as well as port connectivity on port 1556.
    Ensure Windows firewall is turned off.

  • amdcler's avatar
    amdcler
    Level 4
    10 years ago

    Reverse name lookup between master (HostM) and client (HostB) its OK

    telnet 1556 also ok

  • Marianne's avatar
    Marianne
    Level 6
    10 years ago

    My suggestion to test a backup of default db's on the destination client (using NetBackup) is purely to test and confirm comms and connectivity with NBU master server and media server.

    Use bptestbpcd on master and media server (rather than telnet) to test bi-directional connectivity.
    NBU needs to connect on port 1556 in both directions (it seems you have tested in one direction only).

    Create bpcd log folder on the client, the run this command from master and media server (if different):

    bptestbpcd -client <destination-client-name> -debug -verbose

    Post the output as well as bpcd log on the client (copy to bpcd.txt and upload as File attachment).

    Looking at bpclntcmd output, it seems that forward lookup finds shortname and FQDN:
    aliases:     HostB.domen.com     HostB     192.168.130.72

    but reverse lookup only resolves FQDN:
    host 192.168.130.72: HostB.domen.com at 192.168.130.72

    If you are using shortnames in NBU, you need to update DNS reverse lookup to resolve shortname and FQDN.

    Use bpclntcmd on destination client to test forward and reverse name lookup to the master server (hostM) not hostA.

    To troubleshoot restores, ensure that you have dbclient log folder on the destination client and bprd log folder on the master. Restart NBU on the master to enable bprd log.

    To see if you can list/restore backup images for hostA, run this command on hostB:

    bplist -M hostM -C hostA -t 15 -s 05/01/2015 -R /

     

    PS: 
    In future, if the Connect Spam filter quarantines any of your posts, please send a Private Message to one or more of the TAs or Community Admin to publish the post.
    If you re-post again and again and again, you are in fact 'aggravating' the spam filter.