Hi all
1 of my SQL backups failure almost daily. its a full backup. found out few of the logs which points to the problem but didnt know wat steps to take.
logs from ...\veritas\netbackup\logs\user_ops\mssql\logs :::
Batch = c:\Program Files\VERITAS\NetBackup\DbExt\MsSql\full_bkup.bch, Op# = 26
INF - Using backup image clientsystem.MSSQL7.CLIENTSYSTEM.db.DB16.~.7.001of001.20120206070110..C
INF - backup database "DB16" to VIRTUAL_DEVICE='VNBU0-7540-4960-1328533272' 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 <CLIENTSYSTEM.DOMAIN.NET>. Connection timeout is <300> seconds.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]10 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]20 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]30 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]40 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]50 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]60 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]70 percent processed.>.
ERR - Error in CompleteCommand: 0x80770004.
CONTINUATION: - An abort request is preventing anything except termination actions.
ERR - Error in DBthreads::dbclient: 6.
CONTINUATION: - The system cannot find the file specified.
ERR - Error in VxBSAEndData: 6.
CONTINUATION: - The handle used to associate this call with a previous VxBSAInit() call is invalid.
ERR - Error in VDS->Close: 0x80770004.
CONTINUATION: - An abort request is preventing anything except termination actions.
INF - OPERATION #26 of batch c:\Program Files\VERITAS\NetBackup\DbExt\MsSql\full_bkup.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 707(0) seconds.
DBMS MSG - ODBC return code <-1>, SQL State <08S01>, SQL Message <11><[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.>.
DBMS MSG - SQL Message <10054><[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).>
ERR - Unable to login into SQL instance <CLIENTSYSTEM.DOMAIN.NET\> as user <sqldb> using standard connection.
INF - BACKUP STARTED USING Microsoft SQL Server 2005 - 9.00.3080.00 (Intel X86) Sep 6 2009 01:43:32
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Batch = c:\Program Files\VERITAS\NetBackup\DbExt\MsSql\full_bkup.bch, Op# = 28
INF - Using backup image clientsystem.MSSQL7.CLIENTSYSTEM.db.DB17.~.7.001of001.20120206071308..C
INF - backup database "DB17" to VIRTUAL_DEVICE='VNBU0-7540-5152-1328533992' 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 <CLIENTSYSTEM.DOMAIN.NET>. Connection timeout is <300> seconds.
ERR - Error in GetConfiguration: 0x80770003.
CONTINUATION: - The api was waiting and the timeout interval had elapsed.
DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <904><[Microsoft][SQL Native Client][SQL Server]Database 96 cannot be autostarted during server shutdown or startup.>.
DBMS MSG - SQL Message <3013><[Microsoft][SQL Native Client][SQL Server]BACKUP DATABASE is terminating abnormally.>
ERR - Error found executing <backup database "DB17" to VIRTUAL_DEVICE='VNBU0-7540-5152-1328533992' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>.
ERR - Error in VDS->Close: 0x80770004.
CONTINUATION: - An abort request is preventing anything except termination actions.
INF - OPERATION #28 of batch c:\Program Files\VERITAS\NetBackup\DbExt\MsSql\full_bkup.bch FAILED with STATUS 1 (0 is normal)
system logs:
BACKUP failed to complete the command BACKUP DATABASE DB17. Check the backup application log for detailed messages.
BACKUP failed to complete the command BACKUP DATABASE DB16. Check the backup application log for detailed messages.
