Veritas-bu

[Veritas-bu] SQL policy problems

2009-05-11 13:09:31
Subject: [Veritas-bu] SQL policy problems
From: David McWilliams <davidkmcw AT gmail DOT com>
To: NetBackup List <veritas-bu AT mailman.eng.auburn DOT edu>
Date: Mon, 11 May 2009 13:06:04 -0400
I inherited a NBU 6.5 backup environment from a, now gone, colleague. I've got the environment pretty much working again, my only problem now is with some SQL backup. Out of 4 servers, three work fine and the other errors out with a status of 12. When I finally tracked down the logfile, C:\Program Files\Veritas\NetBackup\logs\user_ops\MsSql\Logs, everything looks pretty good until it starts gpoing horribly wrong;

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb  9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Batch = D:\SQL_scripts\SQL.bch, Op# = 2
INF - Using backup image nov-sqlsvr.MSSQL7.NOV-SQLSVR.db.Portal_SERV.~.7.001of001.20090511001522..C
INF - backup database "Portal_SERV" to VIRTUAL_DEVICE='VNBU0-1816-2624-1242015322' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 1
INF - Number of stripes: 1, Number of buffers per stripe 1.
INF - Created VDI object for SQL Server instance <nov-sqlsvr>. Connection timeout is <300> seconds.
ERR - Error in VxBSACreateObject: 3.
    CONTINUATION: - System detected error, operation aborted.
DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3202><[Microsoft][SQL Native Client][SQL Server]Write on "VNBU0-1816-2624-1242015322" 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 Native Client][SQL Server]A nonrecoverable I/O error occurred on file "VNBU0-1816-2624-1242015322:" 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 Native Client][SQL Server]BACKUP DATABASE is terminating abnormally.>
ERR - Error found executing <backup database "Portal_SERV" to VIRTUAL_DEVICE='VNBU0-1816-2624-1242015322' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 1>.
ERR - Error in VDS->Close: 0x80770004.
    CONTINUATION: - An abort request is preventing anything except termination actions.
INF - OPERATION #2 of batch D:\SQL_scripts\SQL.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 910(0) seconds.
INF - BACKUP STARTED USING

I've done a whiole lot of reading and a fair bit of Googling to no availa, any ideas would be greatly appreciate
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
<Prev in Thread] Current Thread [Next in Thread>