Highlighted

Restore MSSQL error

When I restored DB of MS-SQL server, it's showed error: 
"  5  The restore failed to recover the requested files "

and detail session as below:

"

 

  • Jul 02, 2020 10:06:34 AM - begin Restore
  • Jul 02, 2020 10:06:36 AM - Info dbclient (pid=21104) INF - Results of executing <C:\Tmp\Restored\VN-VWL5044_02072020.bch>:
  • Jul 02, 2020 10:06:37 AM - Info dbclient (pid=21104) <0> operations succeeded. <1> operations failed.

 

"

And this is log in C:\Program Files\Veritas\NetBackup\logs\bprd

 

"

10:07:04.989 [6212.6300] <4> is_remote_host_connect_disabled: Failed to read key from bp.conf, errorcode:227. LEGACY_SERVICES_LOOPBACK_ONLY is not defined, using default.
10:07:04.989 [6212.6300] <2> bprd: socket fd from accept() is 1284
10:07:05.004 [6212.6300] <2> listen_loop: request complete
10:07:05.067 [41712.27184] <2> daemon_proxy_proto: Preparing to do daemon protocol for (127.0.0.1:13720 <- 127.0.0.1:65239)
10:07:05.067 [41712.27184] <2> logconnections: BPRD ACCEPT FROM 127.0.0.1.65239 TO 127.0.0.1.13720 fd = 1284
10:07:05.067 [41712.27184] <2> process_request: setsockopt SO_LINGER on 1284 succeeded.
10:07:05.067 [41712.27184] <2> connected_peer: Connection from host VN-BWL5001.hcg.homecredit.net, 127.0.0.1, on non-reserved port 65239
10:07:05.067 [41712.27184] <16> vnet_get_client_name_from_gateway_request: connection_info_json is not json object
10:07:05.067 [41712.27184] <2> copy_preferred_network_list: ../../libvlibs/nbconf.c.2282: pseudo PN for : vn-bwl5001.hcg.homecredit.net
10:07:05.067 [41712.27184] <4> process_request: JWT token found
10:07:05.067 [41712.27184] <2> get_job_initiator: JWT found
10:07:05.067 [41712.27184] <2> get_job_initiator: subject = IntraWebappCall
10:07:05.067 [41712.27184] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1851] in failed file cache ERR=11001 NAME=VN-BWL5001.hcg.homecredit.vn SVC=NULL
10:07:05.067 [41712.27184] <8> vnet_cached_getaddrinfo: [vnet_addrinfo.c:1520] vnet_cached_getaddrinfo_and_update() failed, name=VN-BWL5001.hcg.homecredit.vn, service=NULL, status=6
10:07:05.067 [41712.27184] <8> vnet_same_host_and_update: [vnet_addrinfo.c:3303] vnet_cached_getaddrinfo() failed STAT=6 RV=11001 NAME2=VN-BWL5001.hcg.homecredit.vn
10:07:05.067 [41712.27184] <2> process_request: command C_READ_HOST_CONFIG (73) received
10:07:05.067 [41712.27184] <2> set_audit_identity: JWT found
10:07:05.082 [41712.27184] <2> copy_preferred_network_list: ../../libvlibs/nbconf.c.2282: pseudo PN for : vn-bwl5001.hcg.homecredit.net
10:07:05.082 [41712.27184] <2> read_client: dname=., offline=0, online_at=0 offline_at=0 offlineres=0 onlineres_at=0 offlineres_at=0
10:07:05.082 [41712.27184] <2> read_client: dname=.., offline=0, online_at=0 offline_at=0 offlineres=0 onlineres_at=0 offlineres_at=0
10:07:05.082 [41712.27184] <2> read_client: dname=CO_0, offline=0, online_at=0 offline_at=0 offlineres=0 onlineres_at=0 offlineres_at=0
10:07:05.082 [41712.27184] <2> read_client: dname=host_info, offline=0, online_at=0 offline_at=0 offlineres=0 onlineres_at=0 offlineres_at=0
10:07:05.082 [41712.27184] <2> read_client: dname=OA_0, offline=0, online_at=0 offline_at=0 offlineres=0 onlineres_at=0 offlineres_at=0
10:07:05.098 [41712.27184] <2> logconnections: BPCD CONNECT FROM 10.19.205.202.65240 TO 10.19.205.202.13782 fd = 884
10:07:05.160 [41712.27184] <2> copy_preferred_network_list: ../../libvlibs/nbconf.c.2282: pseudo PN for : vn-bwl5001.hcg.homecredit.net
10:07:05.160 [41712.27184] <2> bpcr_get_version_rqst: bpcd version: 08200000
10:07:05.160 [41712.27184] <2> bpcr_get_version_rqst: bpcd version: 08200000
10:07:05.176 [41712.27184] <2> process_request: EXIT STATUS 0
10:07:05.176 [6212.6300] <4> is_remote_host_connect_disabled: Failed to read key from bp.conf, errorcode:227. LEGACY_SERVICES_LOOPBACK_ONLY is not defined, using default.
10:07:05.176 [6212.6300] <2> bprd: socket fd from accept() is 1284
10:07:05.192 [6212.6300] <2> listen_loop: request complete
10:07:05.254 [6556.21048] <2> daemon_proxy_proto: Preparing to do daemon protocol for (127.0.0.1:13720 <- 127.0.0.1:65242)
10:07:05.254 [6556.21048] <2> logconnections: BPRD ACCEPT FROM 127.0.0.1.65242 TO 127.0.0.1.13720 fd = 1284
10:07:05.254 [6556.21048] <2> process_request: setsockopt SO_LINGER on 1284 succeeded.
10:07:05.254 [6556.21048] <2> connected_peer: Connection from host VN-BWL5001.hcg.homecredit.net, 127.0.0.1, on non-reserved port 65242
10:07:05.254 [6556.21048] <16> vnet_get_client_name_from_gateway_request: connection_info_json is not json object
10:07:05.254 [6556.21048] <2> copy_preferred_network_list: ../../libvlibs/nbconf.c.2282: pseudo PN for : vn-bwl5001.hcg.homecredit.net
10:07:05.254 [6556.21048] <4> process_request: JWT token found
10:07:05.254 [6556.21048] <2> get_job_initiator: JWT found
10:07:05.254 [6556.21048] <2> get_job_initiator: subject = IntraWebappCall
10:07:05.254 [6556.21048] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1851] in failed file cache ERR=11001 NAME=VN-BWL5001.hcg.homecredit.vn SVC=NULL
10:07:05.254 [6556.21048] <8> vnet_cached_getaddrinfo: [vnet_addrinfo.c:1520] vnet_cached_getaddrinfo_and_update() failed, name=VN-BWL5001.hcg.homecredit.vn, service=NULL, status=6
10:07:05.254 [6556.21048] <8> vnet_same_host_and_update: [vnet_addrinfo.c:3303] vnet_cached_getaddrinfo() failed STAT=6 RV=11001 NAME2=VN-BWL5001.hcg.homecredit.vn
10:07:05.254 [6556.21048] <2> process_request: command C_AUTO_UNLOCK_USER (221) received
10:07:05.254 [6556.21048] <2> C_AUTO_UNLOCK_USER: Calling Auto Unlock Method for all users.
10:07:05.270 [6556.21048] <2> read_legacy_touch_file: Found C:\Program Files\Veritas\NetBackupDB\data\vxdbms.conf; requested from (../vxdbms_conf.cpp.1503).
10:07:05.411 [6556.21048] <2> C_AUTO_UNLOCK_USER: EXIT STATUS 365
10:07:05.411 [6212.6300] <4> is_remote_host_connect_disabled: Failed to read key from bp.conf, errorcode:227. LEGACY_SERVICES_LOOPBACK_ONLY is not defined, using default.
10:07:05.411 [6212.6300] <2> bprd: socket fd from accept() is 1396
10:07:05.426 [6212.6300] <2> listen_loop: request complete
10:07:05.473 [22084.23532] <2> daemon_proxy_proto: Preparing to do daemon protocol for (127.0.0.1:13720 <- 127.0.0.1:65243)
10:07:05.473 [22084.23532] <2> logconnections: BPRD ACCEPT FROM 127.0.0.1.65243 TO 127.0.0.1.13720 fd = 1396
10:07:05.473 [22084.23532] <2> process_request: setsockopt SO_LINGER on 1396 succeeded.
10:07:05.473 [22084.23532] <2> connected_peer: Connection from host VN-BWL5001.hcg.homecredit.net, 127.0.0.1, on non-reserved port 65243
10:07:05.473 [22084.23532] <16> vnet_get_client_name_from_gateway_request: connection_info_json is not json object
10:07:05.473 [22084.23532] <2> copy_preferred_network_list: ../../libvlibs/nbconf.c.2282: pseudo PN for : vn-bwl5001.hcg.homecredit.net
10:07:05.473 [22084.23532] <4> process_request: JWT token found
10:07:05.473 [22084.23532] <2> get_job_initiator: JWT found
10:07:05.473 [22084.23532] <2> get_job_initiator: subject = IntraWebappCall
10:07:05.473 [22084.23532] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1851] in failed file cache ERR=11001 NAME=VN-BWL5001.hcg.homecredit.vn SVC=NULL
10:07:05.473 [22084.23532] <8> vnet_cached_getaddrinfo: [vnet_addrinfo.c:1520] vnet_cached_getaddrinfo_and_update() failed, name=VN-BWL5001.hcg.homecredit.vn, service=NULL, status=6
10:07:05.473 [22084.23532] <8> vnet_same_host_and_update: [vnet_addrinfo.c:3303] vnet_cached_getaddrinfo() failed STAT=6 RV=11001 NAME2=VN-BWL5001.hcg.homecredit.vn
10:07:05.473 [22084.23532] <2> process_request: command C_IS_USER_ACCOUNT_LOCKED (220) received
10:07:05.473 [22084.23532] <2> C_IS_USER_ACCOUNT_LOCKED: user_name[vn-administrator], host_name[NOT_APPLICABLE], domain_name[VN-BWL5001], domain_type[0]
10:07:05.473 [22084.23532] <2> decode_spaces: Decoding user name [vn-administrator]
10:07:05.473 [22084.23532] <2> decode_space_in_input: Decoded input value is [vn-administrator]
10:07:05.473 [22084.23532] <2> decode_spaces: Decoding domain name [VN-BWL5001]
10:07:05.473 [22084.23532] <2> decode_space_in_input: Decoded input value is [VN-BWL5001]
10:07:05.504 [22084.23532] <2> read_legacy_touch_file: Found C:\Program Files\Veritas\NetBackupDB\data\vxdbms.conf; requested from (../vxdbms_conf.cpp.1503).
10:07:05.629 [22084.23532] <2> C_IS_USER_ACCOUNT_LOCKED: EXIT STATUS 0
10:07:05.864 [6212.6300] <4> is_remote_host_connect_disabled: Failed to read key from bp.conf, errorcode:227. LEGACY_SERVICES_LOOPBACK_ONLY is not defined, using default.
10:07:05.864 [6212.6300] <2> bprd: socket fd from accept() is 1396
10:07:05.879 [6212.6300] <2> listen_loop: request complete
10:07:05.942 [21816.35200] <2> daemon_proxy_proto: Preparing to do daemon protocol for (127.0.0.1:13720 <- 127.0.0.1:65248)
10:07:05.942 [21816.35200] <2> logconnections: BPRD ACCEPT FROM 127.0.0.1.65248 TO 127.0.0.1.13720 fd = 1396
10:07:05.942 [21816.35200] <2> process_request: setsockopt SO_LINGER on 1396 succeeded.
10:07:05.942 [21816.35200] <2> connected_peer: Connection from host VN-BWL5001.hcg.homecredit.net, 127.0.0.1, on non-reserved port 65248
10:07:05.942 [21816.35200] <16> vnet_get_client_name_from_gateway_request: connection_info_json is not json object
10:07:05.942 [21816.35200] <2> copy_preferred_network_list: ../../libvlibs/nbconf.c.2282: pseudo PN for : vn-bwl5001.hcg.homecredit.net
10:07:05.942 [21816.35200] <4> process_request: JWT token found
10:07:05.942 [21816.35200] <2> get_job_initiator: JWT found
10:07:05.942 [21816.35200] <2> get_job_initiator: subject = IntraWebappCall
10:07:05.942 [21816.35200] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1851] in failed file cache ERR=11001 NAME=VN-BWL5001.hcg.homecredit.vn SVC=NULL
10:07:05.942 [21816.35200] <8> vnet_cached_getaddrinfo: [vnet_addrinfo.c:1520] vnet_cached_getaddrinfo_and_update() failed, name=VN-BWL5001.hcg.homecredit.vn, service=NULL, status=6
10:07:05.942 [21816.35200] <8> vnet_same_host_and_update: [vnet_addrinfo.c:3303] vnet_cached_getaddrinfo() failed STAT=6 RV=11001 NAME2=VN-BWL5001.hcg.homecredit.vn
10:07:05.942 [21816.35200] <2> process_request: command C_UPDATE_USER_LOGIN_DETAILS (222) received
10:07:05.942 [21816.35200] <2> decode_spaces: Decoding user name [vn-administrator]
10:07:05.942 [21816.35200] <2> decode_space_in_input: Decoded input value is [vn-administrator]
10:07:05.942 [21816.35200] <2> decode_spaces: Decoding domain name [VN-BWL5001]
10:07:05.942 [21816.35200] <2> decode_space_in_input: Decoded input value is [VN-BWL5001]
10:07:05.942 [21816.35200] <2> C_UPDATE_USER_LOGIN_DETAILS: user_name[vn-administrator], host_name[NOT_APPLICABLE], domain_name[VN-BWL5001], domain_type[0], auth_status[1]
10:07:05.973 [21816.35200] <2> read_legacy_touch_file: Found C:\Program Files\Veritas\NetBackupDB\data\vxdbms.conf; requested from (../vxdbms_conf.cpp.1503).
10:07:06.114 [21816.35200] <2> C_UPDATE_USER_LOGIN_DETAILS: EXIT STATUS 0
10:07:08.239 [6212.6300] <4> is_remote_host_connect_disabled: Failed to read key from bp.conf, errorcode:227. LEGACY_SERVICES_LOOPBACK_ONLY is not defined, using default.
10:07:08.239 [6212.6300] <2> bprd: socket fd from accept() is 1944
10:07:08.255 [6212.6300] <2> listen_loop: request complete
10:07:08.302 [26244.22224] <2> daemon_proxy_proto: Preparing to do daemon protocol for (127.0.0.1:13720 <- 127.0.0.1:65251)
10:07:08.302 [26244.22224] <2> logconnections: BPRD ACCEPT FROM 127.0.0.1.65251 TO 127.0.0.1.13720 fd = 1944
10:07:08.302 [26244.22224] <2> process_request: setsockopt SO_LINGER on 1944 succeeded.
10:07:08.302 [26244.22224] <2> connected_peer: Connection from host VN-BWL5001.hcg.homecredit.net, 127.0.0.1, on non-reserved port 65251
10:07:08.302 [26244.22224] <16> vnet_get_client_name_from_gateway_request: connection_info_json is not json object
10:07:08.302 [26244.22224] <2> copy_preferred_network_list: ../../libvlibs/nbconf.c.2282: pseudo PN for : vn-bwl5001.hcg.homecredit.net
10:07:08.302 [26244.22224] <4> process_request: JWT token found
10:07:08.302 [26244.22224] <2> get_job_initiator: JWT found
10:07:08.302 [26244.22224] <2> get_job_initiator: subject = VN-BWL5001:VN-Administrator:nt
10:07:08.302 [26244.22224] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1851] in failed file cache ERR=11001 NAME=VN-BWL5001.hcg.homecredit.vn SVC=NULL
10:07:08.302 [26244.22224] <8> vnet_cached_getaddrinfo: [vnet_addrinfo.c:1520] vnet_cached_getaddrinfo_and_update() failed, name=VN-BWL5001.hcg.homecredit.vn, service=NULL, status=6
10:07:08.302 [26244.22224] <8> vnet_same_host_and_update: [vnet_addrinfo.c:3303] vnet_cached_getaddrinfo() failed STAT=6 RV=11001 NAME2=VN-BWL5001.hcg.homecredit.vn
10:07:08.302 [26244.22224] <2> process_request: command C_USER_PASSWORD_EXPIRATION_INFO (266) received
10:07:08.302 [26244.22224] <2> decode_spaces: Decoding user name [VN-Administrator]
10:07:08.302 [26244.22224] <2> decode_space_in_input: Decoded input value is [VN-Administrator]
10:07:08.302 [26244.22224] <2> decode_spaces: Decoding domain name [VN-BWL5001]
10:07:08.302 [26244.22224] <2> decode_space_in_input: Decoded input value is [VN-BWL5001]
10:07:12.927 [26244.22224] <2> C_USER_PASSWORD_EXPIRATION_INFO: Password expiry information logs [: user name is:VN-Administrator and domain name is:VN-BWL5001. Successfully retrieved ADsGetObject info. WinNT user case. using userFlags. Password for this user will never expire. Return code from get_ads_object_info method is:0. Return code using WinNT protocol is :0.]

"

 

 

 

Tags (1)
2 Solutions

Accepted Solutions
Highlighted
Accepted Solution!

Re: Restore MSSQL error

Hi @HCVN_u 

This is the 1st error from dbclient

09:43:30.850 [7676.4340] <2> dbc_get_string: Output = EXIT STATUS 135
09:43:30.850 [7676.4340] <16> VxBSAQueryObject: ERR - dbc_get_string() failed 135

Take a look these TNs

https://vox.veritas.com/t5/NetBackup/SAP-restore-fails-with-quot-dbc-get-string-Output-EXIT-STATUS/t...

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

This is the 2nd error from dbclient

09:50:21.458 [7916.4268] <16> CGlobalInformation::QuerySQLServerInfo: ERR - Error in RegConnectRegistry, opening <HKEY_LOCAL_MACHINE> key on <\\VNHQSQL03>: 53.The text follows:
09:50:21.458 [7916.4268] <1> CGlobalInformation::QuerySQLServerInfo: CONTINUATION: - The network path was not found.

Take a look this TN - https://www.veritas.com/support/en_US/article.100016336

Hope this help.

Thiago

View solution in original post

Highlighted
Accepted Solution!

Re: Restore MSSQL error

I just followed your solutions and try again to restore. Here is the log after running job.

Thanks

View solution in original post

18 Replies
Highlighted

Re: Restore MSSQL error

@HCVN_u, please make sure your .bch restore script is set correctly & all the values matches with defined values in the backup configuration. The log file you shared says the backup policy name in the script does not exists in NetBackup. That means it could not find the backup details using this backup_policy (class) name.

10:06:34.703 [33812.18556] <2> read_class: policy NONE does not exist
10:06:34.703 [33812.18556] <2> process_request: db_getCLASS failed - EC status = the specified policy does not exist in the configuration database

Highlighted

Re: Restore MSSQL error

Thanks so much, i'll check again the *.bch file again

Highlighted

Re: Restore MSSQL error

Hi Pro,

 

can you show me to resolve the "policy NONE does not exist" error. I checked the .bch file but it didn't resolve the error.

i attached .bch file.

Thanks

Highlighted

Re: Restore MSSQL error

Hey

I see in your bch file such entries ==> after valid lines

please remove these  and retry

DATABASE "ELEARNING" ====> name DB
MOVE "ELEARNING"
TO "E:\MSSQL\DATA\ELEARNING_NEW.mdf" ==> new link mdf files
MOVE "ELEARNING_log"
TO "T:\MSSQL\LOG\ELEARNING_NEW_log.ldf" ==> new link log files
NBIMAGE "VN-VWL5044.MSSQL7.VN-VWL5044.db.ELEARNING.~.7.001of001.20200613185853..C"
SQLHOST "VNHQSQL01" ==> host need to restore DB
NBSERVER "VN-BWL5001" ==> Masster Server
BROWSECLIENT "VN-VWL5044" ==> Client backed up DB

all these ==> are not welcome as well what is after that.... my take.

Highlighted

Re: Restore MSSQL error

Hi Pro,

That lines which I added more to explain.

Full script as below:


OPERATION RESTORE
OBJECTTYPE DATABASE
RESTORETYPE MOVE
DATABASE "ELEARNING"
MOVE "ELEARNING"
TO "E:\MSSQL\DATA\ELEARNING_NEW.mdf"
MOVE "ELEARNING_log"
TO "T:\MSSQL\LOG\ELEARNING_NEW_log.ldf"
NBIMAGE "VN-VWL5044.MSSQL7.VN-VWL5044.db.ELEARNING.~.7.001of001.20200613185853..C"
SQLHOST "VNHQSQL01"
NBSERVER "VN-BWL5001"
BROWSECLIENT "VN-VWL5044"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE

When i run scripts it same error as first post

Thanks

Highlighted

Re: Restore MSSQL error

Hi Pro,

In my scripts, it didn't have some lines: 

"
OPERATION RESTORE
OBJECTTYPE DATABASE
RESTORETYPE MOVE
DATABASE "ELEARNING"
MOVE "ELEARNING"
TO "E:\MSSQL\DATA\ELEARNING_NEW.mdf"
MOVE "ELEARNING_log"
TO "T:\MSSQL\LOG\ELEARNING_NEW_log.ldf"
NBIMAGE "VN-VWL5044.MSSQL7.VN-VWL5044.db.ELEARNING.~.7.001of001.20200613185853..C"
SQLHOST "VNHQSQL01"
NBSERVER "VN-BWL5001"
BROWSECLIENT "VN-VWL5044"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE

"

The error was still appeared when i ran it

Thanks

Highlighted

Re: Restore MSSQL error

@HCVN_u have you created 'altnames' folders and file(s) on the master server to authorize redirected restores? 

Did you restart NetBackup on the master server after creating bprd folder? 
There is important info missing from the attachment, which makes me believe that the NBU Request Service was not restarted after folder was created. 

We need to see info such as :
.... <2> restorefiles:    browse_client =
.... <2> restorefiles:    requesting_client =
.... <2> restorefiles:    destination_client =
.... <2> restorefiles:    requesting_client_hostname =
.... <2> restorefiles:    destination_client_hostname =

Please restart NBU Request Service on the master before attempting another restore. 

Ensure that the following log folders exist on the destination client: 
dbclient and bphdb
Increase logging level for this client to 3. 

Highlighted

Re: Restore MSSQL error

@Marianne :

have you created 'altnames' folders and file(s) on the master server to authorize redirected restores?  ==> i created folders as image attached.

Did you restart NetBackup on the master server after creating bprd folder?   ==> I restarted services and master server.

We need to see info such as :
.... <2> restorefiles:    browse_client =
.... <2> restorefiles:    requesting_client =
.... <2> restorefiles:    destination_client =
.... <2> restorefiles:    requesting_client_hostname =
.... <2> restorefiles:    destination_client_hostname =

====> Please show me how to find these information.

Ensure that the following log folders exist on the destination client: 
dbclient and bphdb  ===> in the "C:\Program Files\Veritas\NetBackup\logs\bprd" I didn't see two file logs

Thanks

Highlighted

Re: Restore MSSQL error


@HCVN_u wrote:

  ==> i created folders as image attached.

Did you restart NetBackup on the master server after creating bprd folder?   ==> I restarted services and master server.


All good. But then I'd expect to see more info in bprd log about the client's browse and restore request.


We need to see info such as :
.... <2> restorefiles:    browse_client =
====> Please show me how to find these information.

You simply search the bprd log file for the word 'browse'.
So, that's my issue - I cannot find anything in the log that you provided.


Ensure that the following log folders exist on the destination client: 
dbclient and bphdb  ===> in the "C:\Program Files\Veritas\NetBackup\logs\bprd" I didn't see two file logs


Seems you misunderstood.

bprd log folder must be on the master server, not on the client. 
NetBackup Request Service (bprd.exe) only runs on a master server.  This is where we track requests from client, comms with NBU database, restore instruction to bpbrm on the media server, etc.

You need to create bpdbh and dbclient log directories on the client under <install-path>\Veritas\NetBackup\logs.
Actually, for a restore we do not need bphdb, only dbclient. 
Important to increase the client logging level to 3. 
I have seen with restore troubleshooting that the default level 0 is simply not enough. 

Highlighted

Re: Restore MSSQL error

Dear @Marianne , Thanks for your supporting, 

I stopped the services NBU and change folder 'bprd' to 'bprd.bk' then i restart all of services. and try to restore again. But i still not seen these lines ( i increase log to level 3): 

.... <2> restorefiles:    browse_client =
.... <2> restorefiles:    requesting_client =
.... <2> restorefiles:    destination_client =
.... <2> restorefiles:    requesting_client_hostname =
.... <2> restorefiles:    destination_client_hostname =

maybe something went wrong, when i configure??

Thanks

 

Highlighted

Re: Restore MSSQL error

I do not understand either. 
There is no evidence of any browse or restore request in the log. 
The log starts at 16:28:03 and ends at 16:29:04. 1 minute later.
What time did you attempt the restore? 

I see this line in bprd log:
process_request: log_job_info request = 329199 148 21227 dbclient 8812 120 INF - Results of executing <C:\Tmp\Restored\VN-VWL5044_09072020.bch>: <0> operations succeeded. <1> operations failed.

I have no idea why bprd only logs the failure and not the initial connection or restore request.

Have you created dbclient log on the client? 
We need to see where the restore request is sent and the comms that is received back from the master. 

Highlighted

Re: Restore MSSQL error

Dear @Marianne 

Sorry for this incovenience....I created bprd on clients but i didn't see any log which was create after the job was run.

I post log and command restore files again.

Thanks

Highlighted

Re: Restore MSSQL error


@HCVN_u wrote:

Dear @Marianne 

Sorry for this incovenience....I created bprd on clients but i didn't see any log which was create after the job was run.

NO! PLEASE!!! 

The bprd log folder must be created on the MASTER server.
dbclient folder on the SQL client.

This is what I posted last Thursday:

bprd log folder must be on the master server, not on the client. 
NetBackup Request Service (bprd.exe) only runs on a master server.  This is where we track requests from client, comms with NBU database, restore instruction to bpbrm on the media server, etc.

 

Highlighted

Re: Restore MSSQL error

Hi @Marianne 

Thanks many for your patience,

I checked clients, and i created folder dbclient on client servers. ( log level 3 was increased).

I just seen the dbclient folders on master server. is this wrong way?

Highlighted

Re: Restore MSSQL error

Please post restore client's dbclient log after failed restore attempt.

dbclient on the master is of no use.

Highlighted

Re: Restore MSSQL error

Highlighted
Accepted Solution!

Re: Restore MSSQL error

Hi @HCVN_u 

This is the 1st error from dbclient

09:43:30.850 [7676.4340] <2> dbc_get_string: Output = EXIT STATUS 135
09:43:30.850 [7676.4340] <16> VxBSAQueryObject: ERR - dbc_get_string() failed 135

Take a look these TNs

https://vox.veritas.com/t5/NetBackup/SAP-restore-fails-with-quot-dbc-get-string-Output-EXIT-STATUS/t...

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

This is the 2nd error from dbclient

09:50:21.458 [7916.4268] <16> CGlobalInformation::QuerySQLServerInfo: ERR - Error in RegConnectRegistry, opening <HKEY_LOCAL_MACHINE> key on <\\VNHQSQL03>: 53.The text follows:
09:50:21.458 [7916.4268] <1> CGlobalInformation::QuerySQLServerInfo: CONTINUATION: - The network path was not found.

Take a look this TN - https://www.veritas.com/support/en_US/article.100016336

Hope this help.

Thiago

View solution in original post

Highlighted
Accepted Solution!

Re: Restore MSSQL error

I just followed your solutions and try again to restore. Here is the log after running job.

Thanks

View solution in original post