Hi All,
I need help with SQL Server backups.
I have the following log from the Client:
OPERATION BACKUP
DATABASE "Zambia"
SQLHOST "Prepaidsvr1-Ndl"
NBSERVER "BACKUP-SVR-PR.ZESCOCORP.ZESCOAD.ZESCO.CO.ZM"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
INF - BACKUP STARTED USING
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )
Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\ecash_daily_bkup.bch, Op# = 1
INF - Using backup image Prepaidsvr1-Ndl.MSSQL7.PREPAIDSVR1-NDL.db.Zambia.~.7.001of001.20140927094824..C
INF - backup database "Zambia" to VIRTUAL_DEVICE='VNBU0-3100-6416-1411804118' 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 <Prepaidsvr1-Ndl>. Connection timeout is <300> seconds.
Backup started Sat Sep 27 09:49:24 2014
09:50:39 Initiating backup
09:50:58 INF - Server status = 96
09:51:10 INF - Backup by Administrator on client prepaidsvr1-ndl.zescocorp.zescoad.zesco.co.zm using policy E-cash_daily_bkups, sched Default-Application-Backup:unable to allocate new media for backup, storage unit has none available
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][ODBC SQL Server Driver][SQL Server]Write on "VNBU0-3100-6416-1411804118" 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][ODBC SQL Server Driver][SQL Server]A nonrecoverable I/O error occurred on file "VNBU0-3100-6416-1411804118:" 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 <3013><[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.>
ERR - Error found executing <backup database "Zambia" to VIRTUAL_DEVICE='VNBU0-3100-6416-1411804118' 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 #1 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\ecash_daily_bkup.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 333(333) seconds.
INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\ecash_daily_bkup.bch>:
<0> operations succeeded. <1> operations failed.
