Forum Discussion

HCVN_u's avatar
HCVN_u
Level 3
5 years ago

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...
Windows Server 2016
Marianne's avatar
Marianne
Level 6

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. 

HCVN_u's avatar
HCVN_u
Level 3
5 years ago

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

  • Marianne's avatar
    Marianne
    Level 6
    5 years ago
    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.

     

  • HCVN_u's avatar
    HCVN_u
    Level 3
    5 years ago

    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?

  • Marianne's avatar
    Marianne
    Level 6
    5 years ago

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

    dbclient on the master is of no use.

  • Thiago_Ribeiro's avatar
    Thiago_Ribeiro
    Moderator
    5 years ago

    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/td-p/298243

    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

  • HCVN_u's avatar
    HCVN_u
    Level 3
    4 years ago

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

    Thanks