cancel
Showing results for 
Search instead for 
Did you mean: 

MSSQL Backup Error

RansOupZI
Level 3

Hi All,

I'm still kind of new to NetBackup and hope to seek for some assistance to the issue my environment faced. Unable to backup our MS-SQL despite several tries and went through the SQL Admin Guide.

Master Server is NetBackup version 8.0. We have given all necessary roles and rights to the administrator account. NetBackup Client, Legacy Network Servces and MS SQL Client have added the credentials. 

Please do pardon me as due to security purpose, hostnames and instances have change to something else.

Outcome of the backup:
# ------------------------------------------------------
# This batch file was generated for intelligent policy:
# MSSQL_Backup
# From the intelligent policy file:
# input.1324.0.0209117.141619
# ------------------------------------------------------
OPERATION BACKUP
DATABASE "owner"
OBJECTTYPE DATABASE
NBSERVER "Apple"
SQLINSTANCE "Fruits"
SQLHOST "Banana"
POLICY "MSSQL_Backup"
NBSCHED "Automatic_Backup"
CATNAME "Banana"
BLOCKSIZE 7
MAXTRANSFERSIZE 6
NUMBUFS 2
STRIPES 1
SQLCOMPRESSION FALSE
VERIFYOPTION NONE
ENDOPER TRUE
OPERATION BACKUP
DATABASE "design"
OBJECTTYPE DATABASE
NBSERVER "Apple"
SQLINSTANCE "Fruits"
SQLHOST "Banana"
POLICY "MSSQL_Backup"
NBSCHED "Automatic_Backup"
CATNAME "Banana"
BLOCKSIZE 7
MAXTRANSFERSIZE 6
NUMBUFS 2
STRIPES 1
SQLCOMPRESSION FALSE
VERIFYOPTION NONE
ENDOPER TRUE
OPERATION BACKUP
DATABASE "msdb"
OBJECTTYPE DATABASE
NBSERVER "Apple"
SQLINSTANCE "Fruits"
SQLHOST "Banana"
POLICY "MSSQL_Backup"
NBSCHED "Automatic_Backup"
CATNAME "Banana"
BLOCKSIZE 7
MAXTRANSFERSIZE 6
NUMBUFS 2
STRIPES 1
SQLCOMPRESSION FALSE
VERIFYOPTION NONE
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Duration5"
OBJECTTYPE DATABASE
NBSERVER "Apple"
SQLINSTANCE "Fruits"
SQLHOST "Banana"
POLICY "MSSQL_Backup"
NBSCHED "Automatic_Backup"
CATNAME "Banana"
BLOCKSIZE 7
MAXTRANSFERSIZE 6
NUMBUFS 2
STRIPES 1
SQLCOMPRESSION FALSE
VERIFYOPTION NONE
ENDOPER TRUE
INF - Intelligent policy initiated by server <Apple>
INF - Intelligent policy <MSSQL_Backup> is valid. The input file <C:\Program Files\Veritas\NetBackup\dbext\mssql\input.1324.0.0209117.141619> has been parsed successfully
INF - Instance server name resolved to: <Banana>
INF - Intelligent policy <MSSQL_Backup> has resulted in <4> batch operation(s).
INF - Intelligent policy <MSSQL_Backup>: <4> operation(s) will protect full databases.
INF - Intelligent policy preprocessing has finished, created temporary batch file <__14_16_21_613_00.bch>, and submitted it to the backend agent for processing

INF - BACKUP STARTED USING
Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Enterprise Evaluation Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
Batch = __14_16_21_613_00.bch, Op# = 1
INF - Using backup image Banana.MSSQL7.Banana\Fruits.db.owner.~.7.001of001.20170209141623..C
INF - backup database "owner" to VIRTUAL_DEVICE='VNBU0-108-4860-1486620984' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Setting backup catalog name to: Banana
INF - Created VDI object for SQL Server instance <Fruits>. Connection timeout is <300> seconds.
Backup started Thu Feb 09 14:16:25 2017

ERR - Error in VxBSACreateObject: 3.
CONTINUATION: - System detected error, operation aborted.
ERR - Error in GetCommand: 0x80770004.
CONTINUATION: - An abort request is preventing anything except termination actions.
DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3202><[Microsoft][SQL Server Native Client 11.0][SQL Server]Write on "VNBU0-108-4860-1486620984" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)>.
DBMS MSG - SQL Message <3271><[Microsoft][SQL Server Native Client 11.0][SQL Server]A nonrecoverable I/O error occurred on file "VNBU0-108-4860-1486620984:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).>
DBMS MSG - SQL Message <3013><[Microsoft][SQL Server Native Client 11.0][SQL Server]BACKUP DATABASE is terminating abnormally.>
ERR - Error found executing <backup database "owner" to VIRTUAL_DEVICE='VNBU0-108-4860-1486620984' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>.
INF - OPERATION #1 of batch __14_16_21_613_00.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 925(925) seconds.
INF - BACKUP STARTED USING
Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Enterprise Evaluation Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
Batch = __14_16_21_613_00.bch, Op# = 2
INF - Using backup image Banana.MSSQL7.Banana\Fruits.db.design.~.7.001of001.20170209143151..C
INF - backup database "design" to VIRTUAL_DEVICE='VNBU0-108-820-1486621912' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Setting backup catalog name to: Banana
INF - Created VDI object for SQL Server instance <Fruits>. Connection timeout is <300> seconds.
ERR - Error in VxBSACreateObject: 3.
CONTINUATION: - System detected error, operation aborted.
ERR - Error in GetCommand: 0x80770004.
DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3202><[Microsoft][SQL Server Native Client 11.0][SQL Server]Write on "VNBU0-108-820-1486621912" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)>.
CONTINUATION: - An abort request is preventing anything except termination actions.
DBMS MSG - SQL Message <3271><[Microsoft][SQL Server Native Client 11.0][SQL Server]A nonrecoverable I/O error occurred on file "VNBU0-108-820-1486621912:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).>
DBMS MSG - SQL Message <3013><[Microsoft][SQL Server Native Client 11.0][SQL Server]BACKUP DATABASE is terminating abnormally.>
ERR - Error found executing <backup database "design" to VIRTUAL_DEVICE='VNBU0-108-820-1486621912' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>.
INF - OPERATION #2 of batch __14_16_21_613_00.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 920(920) seconds.
INF - BACKUP STARTED USING
Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Enterprise Evaluation Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
Batch = __14_16_21_613_00.bch, Op# = 3
INF - Using backup image Banana.MSSQL7.Banana\Fruits.db.msdb.~.7.001of001.20170209144714..C
INF - backup database "msdb" to VIRTUAL_DEVICE='VNBU0-108-3200-1486622836' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Setting backup catalog name to: Banana
INF - Created VDI object for SQL Server instance <Fruits>. Connection timeout is <300> seconds.
ERR - Error in VxBSACreateObject: 3.
CONTINUATION: - System detected error, operation aborted.
ERR - Error in GetCommand: 0x80770004.
DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3202><[Microsoft][SQL Server Native Client 11.0][SQL Server]Write on "VNBU0-108-3200-1486622836" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)>.
CONTINUATION: - An abort request is preventing anything except termination actions.
DBMS MSG - SQL Message <3271><[Microsoft][SQL Server Native Client 11.0][SQL Server]A nonrecoverable I/O error occurred on file "VNBU0-108-3200-1486622836:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).>
DBMS MSG - SQL Message <3013><[Microsoft][SQL Server Native Client 11.0][SQL Server]BACKUP DATABASE is terminating abnormally.>
ERR - Error found executing <backup database "msdb" to VIRTUAL_DEVICE='VNBU0-108-3200-1486622836' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>.
INF - OPERATION #3 of batch __14_16_21_613_00.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 921(921) seconds.
INF - BACKUP STARTED USING
Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Enterprise Evaluation Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
Batch = __14_16_21_613_00.bch, Op# = 4
INF - Using backup image Banana.MSSQL7.Banana\Fruits.db.Duration5.~.7.001of001.20170209150238..C
INF - backup database "Duration5" to VIRTUAL_DEVICE='VNBU0-108-4640-1486623759' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Setting backup catalog name to: Banana
INF - Created VDI object for SQL Server instance <Fruits>. Connection timeout is <300> seconds.

 

10 REPLIES 10

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello,

 

error "The I/O operation has been aborted because of either a thread exit or an application request" is very generic. NetBackup cannot "accept" sql backup stream sent from the db server for a reason.

Any status code(s) in Activity Monitor?

Both-direction connetions to port 1556 working?

Mere filesystem backup is working for the client?

HostName resolution OK?

etc,

regards

Michal

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Answers to @Michal_Mikulik1's questions will be great.

Please create these log folders under ...\NetBackup\logs  for troubleshooting:

On master: bprd (restart NBU after creating the folder)

On SQL client: dbclient (no restart needed)

Above 2 logs will show if initial connection from SQL client to master server is fine (port connection as well as forward and reverse name lookup).

Hi,

Error code show was 41.

We have no issues with file level backups. There are no firewalls curently.

No DNS but added hostfile.

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Connection timeout....

Difference between Agent backup and file-level backup is that the SQL script initiates a connection to the master server.

There is either a problem with forward and reverse name lookup or OS firewalls.

What is the output from these commands on the SQL client?

hostname
bpclntcmd -self
bpclntcmd -pn
(bpclntcmd command is in ...netbackup\bin)

The last command will initiate a connection to the master server, similar to SQL backup.
This will show us if connection is successful and how the master server resolves the client IP to hostname. 

 

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Hi Marianne,

Apologies for the delay due to held up by work but I got some of the logs attached. Probably would be some help.

Regarding your previous reply, I have tested the following command below with no error show.
bpclntcmd -pn
bpclntcmd -self
bpclntcmd -master/media
bpclntcmd -ip

bpgetconfig -M <client_hostname> -x
bptestbpcd -client <client_hostname> -verbose

Regards,
RansOupZI

bprd log shows name resolution trouble

" Unable to look up host name for IP address 192.168.1.5: No such host is known.  "

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
Thanks Will. It is after hours in my part of the world.
I can only view .txt files on my phone.

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
I was not expecting error messages from bpclntcmd or hostname commands.
Just interested to see the output.

@RansOupZI  did you fix the name resolution trouble yet?