SQL Backup Error

[Deepak_G]

I am trying to take backup of a SQL DB using Netbackup (Linux - NBU 7.0.1). I am getting the below error when I try to run backup. Can someone help with this.

OPERATION BACKUP
DATABASE "LIMS_PRODUCTION"
SQLHOST "DCWWPDLBWSQL02V"
SQLINSTANCE "LIMS"
NBSERVER "SANBACK2"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE

INF - BACKUP STARTED USING
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)
Jun 17 2011 00:54:03
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\Full_Backup.bch, Op# = 1
INF - Using backup image DCWWPDLBWSQL02V.MSSQL7.DCWWPDLBWSQL02V\LIMS.db.LIMS_PRODUCTION.~.7.001of001.20120612161422..C
INF - backup database "LIMS_PRODUCTION" to VIRTUAL_DEVICE='VNBU0-4120-4672-1339514063' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <LIMS>. Connection timeout is <300> seconds.
Backup started Tue Jun 12 16:14:23 2012

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.
ERR - Error in VDS->Close: 0x80770004.
    CONTINUATION: - An abort request is preventing anything except termination actions.
INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\Full_Backup.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 1929(1929) seconds.
INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\Full_Backup.bch>:
<0> operations succeeded. <1> operations failed.
INF - The following object(s) were not backed up successfully.
INF - LIMS_PRODUCTION

[Mark_Solutions]

Check the System and Application logs on the SQL Server for clues - sounds like a VSS error - there are some MS hotfixes but it depends on what error is in the event logs

Also try running:

vssadmin list writers

on the SQL Server to see if they are stabke

Finally - check for orphaned dbbackex processes on the SQL Server and that no maintenance plans are running that could conflict with the NBU backups

Hope this helps

[Marianne]

Not enough info in progress log. Please create dbclient log folder on client and retry backup. Post log as attachment. Common problem is comms between master and client. Backup request is initiated on client. Master needs to resolve Client IP to hostname that matches client name in policy. Please double-check DNS and/or hosts entries.

[watsons]

This type of error code normally has something to do with SQL application virtual device, or SQLVDI.dll (library file), you might want to check the application event log to look for more details.

Some related technotes:

http://www.symantec.com/docs/TECH42958
http://www.symantec.com/docs/TECH16981