cannot connect on socket(25)

You need to check if SQL client can connect to the master server on port 1556.

Is xq2 the master server?
If not, check backup script and ensure that Server entry is the master server name.

Run the following command on SQL client:

bpclntcmd -pn
(In ....\netbackup\bin folder)

Please show us the output.

On the master server, ensure bprd log folder exists under netbackup\logs.
If not, create the folder and restart NBU Request service.

See in bprd if connection request is received from client IP address/hostname.

Run the following command on SQL client:

C:\Program Files\Veritas\NetBackup\bin>bpclntcmd -pn

expecting response from server xq2

XQ1 XQ1 100.112.2.140 57824

We now need to see bprd log on the master after SQL backup failure as well as full dblient log.

Please copy the logs to bprd.txt and dbclient.txt, then upload as File attachments.

Based on what we see in these logs, we may request other logs.

So, ensure that these log folders exist before next backup attempt:

On media server: bptm and bpbrm

For now - only post above 2 logs.
Important that we get these logs that cover the same backup attempt / time frame.

in xq2:

in bprd folders, and in dbclient folders is 0KB.

in xq1:

in bprd folders is nothing

You need to restart NBU Request service on the master server after bprd log folder is created.
Only then will this log be enabled.

We need to see master's bprd log.

From the dbclient log, it seems that appropriate policy cannot be found for the client.
So, we need to see in bprd log how master server is interpreting the Client's backup request.

I restart NBU Request service on the master server.

the master's bprd log is:

Do you have any snapshot enabled, in the policy attributes, for this policy? As per the bprd log, it seems like the policy type is MS-SQL-SERVER (-pt 15).

bprd shows:

12:19:40.962 [8104.5712] <2> bpcd_fork_cmd: bpfis msg = FTL - can't accept from xq2: errno: 0
12:19:40.977 [8104.5712] <2> bpcd_fork_cmd: bpfis msg = FTL - snapshot creation failed, status 25

Have you tried disabling snapshot, in the policy attributes and trying a backup?

Please tell us more about the policy - there seems to be a snapshot attempt that is failing.

INFO Error in VxBSAWaitForFileListStatus: 36.
INFO The creation of the frozen image failed.

Also tell us how the policy is kicked off and if policy name is hard-coded in the SQL script?

I see a request in bprd log for policy name Job_testdb, as well as for policy name testdb

and this error:

policy testdb does not exist

Please show us the SQL policy:
bppllist <policy-name> -L

also show us the backup script on the client: 

C:\Program Files\Veritas\NetBackup\DbExt\MsSql\fan\testdb.bch

the SQL backup job configuration as shown in Fig.

testdb.bch  is  testdb.txt.

Thanks!

Why do you have snapshot and offhost option selected?

Have you gone through the requirements and configuration steps in NetBackup Snapshot Client Administrator's Guide ? As well as the Snapshot Client chapter in NetBackup for Microsoft SQL Server Administrator's Guide ?

For now, please de-select the Snapshot option in the policy and take your time to read through above 2 manuals to ensure all requirements and configuration is in place.