cancel
Showing results for 
Search instead for 
Did you mean: 

USER - An instance of SQL Server was not found on this client backup error code 2

jjimenez2
Level 5

Hi Guys,

Can you help me with sql error.

The script not on read mode.

file system backup type is ok.

Only those sql backup.

Info bphdb (pid=6964) Backup started
Sep 21, 2021 8:27:17 AM - Info bphdb (pid=6964) The script <C:\Program Files\VERITAS\NetBackup\scripts\MsSql\sample_backup.bch> has been approved to run and is stored locally.
Sep 21, 2021 8:27:17 AM - connected; connect time: 0:00:00
Sep 21, 2021 8:27:43 AM - Info dbclient (pid=8824) USER - An instance of SQL Server was not found on this client.
Sep 21, 2021 8:27:43 AM - Info dbclient (pid=8824) INF - Results of executing <C:\Program Files\VERITAS\NetBackup\scripts\MsSql\sample_backup.bch>: 
Sep 21, 2021 8:27:43 AM - Info dbclient (pid=8824) <0> operations succeeded. <0> operations failed.
Sep 21, 2021 8:28:03 AM - Error bpbrm (pid=8109) from client client.hostname.com : ERR - command failed: none of the requested files were backed up (2)
Sep 21, 2021 8:28:03 AM - Error bpbrm (pid=8109) from client client.hostname.com: ERR - bphdb exit status = 2: none of the requested files were backed up
Sep 21, 2021 8:28:04 AM - Info bphdb (pid=6964) done. status: 2: none of the requested files were backed up
Sep 21, 2021 8:28:04 AM - end writing
none of the requested files were backed up  (2)

 

 

1 REPLY 1

davidmoline
Level 6
Employee

Hi @jjimenez2 

What the error is saying is that the agent is unable to find the SQL server specified in the script. You will need to check that the client is running SQL server (and a supported version), and the definitions in the script are correct. 

You appear to be using a sample script - have you ensured that it is setup correctly? 

Have you also ensured that the pre-requisites for running SQL via batch scripts have been met? Refer to the NetBackup MS-SQL Admin Guide for details. 

For more detilas about the error, also you can review the bphdb and dbclient logs on the client.

Cheers
David