01-13-2018 08:13 PM
I have a SQL Server clustered instance and backups have been succeeding. I am using a backup LAN to perform backups routinely. I attempted a restore this weekend to the same cluster using a MOVE script but I get the following output from netbackup Administrator:
NB: I have tried creating the file /usr/openv/netbackup/db/altnames/No.Restrictions but it does not seem to be working.
01/14/2018 03:56:18 - begin Restore
01/14/2018 03:56:19 - Info dbclient (pid=20940) INF - RESTORE STARTED USING
01/14/2018 03:56:19 - Info dbclient (pid=20940) Microsoft SQL Server 2016 (SP1-CU3) (KB4019916) - 13.0.4435.0 (X64)
01/14/2018 03:56:19 - Info dbclient (pid=20940) Apr 27 2017 17:36:12
01/14/2018 03:56:19 - Info dbclient (pid=20940) Copyright (c) Microsoft Corporation
01/14/2018 03:56:19 - Info dbclient (pid=20940) Enterprise Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: )
01/14/2018 03:56:19 - Info dbclient (pid=20940) Batch = C:\nbu\scripts\restore_acce_31122017.bch, Op# = 1.
01/14/2018 03:56:19 - Info dbclient (pid=20940) INF - Restoring from <4> images. The first is <EPN-SQLNCDB-01.MSSQL7.EPN-SQLNCDB-SQL\LG01.db.AccelerateDb.~.7.001of004.20171231210738..C>.
01/14/2018 03:56:19 - Info dbclient (pid=20940) INF - restore database "AccelerateDb_UAT" from VIRTUAL_DEVICE='VNBU0-20940-21420-1515895428', VIRTUAL_DEVICE='VNBU1-20940-21420-1515895428', VIRTUAL_DEVICE='VNBU2-20940-21420-1515895428', VIRTUAL_DEVICE='VNBU3-20940-21420-1515895428' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 8, replace , norecovery, move 'Accelerate' to 'M:\INST1_MISC_DATA_01\DATA\Accelerate_uat.mdf', move 'Accelerate_log' to 'N:\INST1_MISC_LOG\LOG\Accelerate_log_uat.ldf', replace
01/14/2018 03:56:19 - Info dbclient (pid=20940) INF - Number of stripes: 4, Number of buffers per stripe 2.
01/14/2018 03:56:19 - Info dbclient (pid=20940) INF - Created VDI object for SQL Server instance <LG01>. Connection timeout is <300> seconds.
01/14/2018 03:56:21 - Info dbclient (pid=20940) ERR - Error in VxBSAGetMultipleObjects: 26.
01/14/2018 03:56:21 - Info dbclient (pid=20940) CONTINUATION: - There is no copy of the requested object.
01/14/2018 03:56:24 - Info dbclient (pid=20940) INF - OPERATION #1 of batch C:\nbu\scripts\restore_acce_31122017.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 7(7) seconds.
01/14/2018 03:56:26 - Info dbclient (pid=20940) INF - Results of executing <C:\nbu\scripts\restore_acce_31122017.bch>:
01/14/2018 03:56:26 - Info dbclient (pid=20940) <0> operations succeeded. <1> operations failed.
01-14-2018 11:39 PM
SQL restore using a backup network is normally a bit challenging. On a cluster, even more so.
Before we start troubleshooting, we need to understand your specific setup as per the examples from the NBU for SQL admin guide:
node1 client name: sqlhost1
node2 client name: sqlhost2
node 1 Backup NIC client name: sqlhost1-NB
node 2 Backup NIC client name: sqlhost2-NB
Virtual name of SQL Server : virtsql
SQL Server virtual name on backup network: virtsql-NB
With the above examples, we can go to this section in the manual:
"Performing restores of SQL Server cluster when you have multiple NICs”
The browse setup is explained and modifications to the restore script:
Generated script:
OPERATION RESTORE
OBJECTTYPE DATABASE
DATABASE "ACCOUNTING"
NBIMAGE "SQLHOST1.MSSQL7.VIRTSQL.db.ACCOUNTING.~.7.001of001.20040306111309..C"
SQLHOST "VIRTSQL"
NBSERVER "THOR"
BROWSECLIENT "VIRTSQL"
.......
Modification:
OPERATION RESTORE
OBJECTTYPE DATABASE
DATABASE "ACCOUNTING"
NBIMAGE "SQLHOST1.MSSQL7.VIRTSQL.db.ACCOUNTING.~.7.001of001.20040306111309..C"
SQLHOST "VIRTSQL"
NBSERVER "THOR"
BROWSECLIENT "VIRTSQL-NB"
......
With the above in mind - could you give us details of your setup?
Along with these logs:
On destination node: level 3 dbclient log (renamed to dbclient.txt)
On master server: bprd log (renamed to bprd.txt)
(Restart NBU if bprd does not exist and needs to be created before next attempt)
01-15-2018 03:43 AM
Hi @Kenneth_Igiri,
Just to complement the information that @Marianne said, if possible also check this TN?
NetBackup SQL Restore Fails with Error in VxBSAGetMultipleObjects: 26
Thiago