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.]
"
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 135Take a look these TNs
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
I just followed your solutions and try again to restore. Here is the log after running job.
Thanks