10-19-2009 04:19 AM
I am using WIn2003 Server with Veritas Netbackup Server6.5.......I am trying to take the backup of MS SQL but having the below error. i can take the backup of flat files from the same client machine but not able to take the backup of SQL database. i can successfully ping each other and the names/IP are being resolved successfully
ACTIVITY MONITOR
10/19/2009 5:04:19 PM - requesting resource DotNet-
10/19/2009 5:04:19 PM - requesting resource veritas.NBU_CLIENT.MAXJOBS.Server-1
10/19/2009 5:04:19 PM - requesting resource veritas.NBU_POLICY.MAXJOBS.DotnetDatabase_245_testDB
10/19/2009 5:04:20 PM - granted resource veritas.NBU_CLIENT.MAXJOBS.Server-1
10/19/2009 5:04:20 PM - granted resource veritas.NBU_POLICY.MAXJOBS.DotnetDatabase_245_testDB
10/19/2009 5:04:20 PM - granted resource MediaID=@aaaaT;Path=M:\DotNet;MediaServer=Veritas
10/19/2009 5:04:20 PM - granted resource DotNet-
10/19/2009 5:04:20 PM - estimated 0 kbytes needed
10/19/2009 5:04:21 PM - started process bpbrm (10196)
10/19/2009 5:04:22 PM - connecting
10/19/2009 5:04:23 PM - connected; connect time: 00:00:01
10/19/2009 5:09:38 PM - end writing
none of the requested files were backed up(2)
STATUS VIEW from Client SIde
OPERATION BACKUP
DATABASE "DotnetDatabase"
SQLHOST "SERVER-1"
NBSERVER "VERITAS"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
INF - BACKUP STARTED USING
Microsoft SQL Server 2005 - 9.00.3200.00 (X64)
Oct 2 2007 12:23:02
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\Veritas.Database.bch, Op# = 1
INF - Using backup image SERVER-1.MSSQL7.SERVER-1.db.DotnetDatabase.~.7.001of001.20091019135341..C
INF - backup database "DotnetDatabase" to VIRTUAL_DEVICE='VNBU0-136-4248-1255942421' 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 <SERVER-1>. Connection timeout is <300> seconds.
Backup started Mon Oct 19 13:54:50 2009
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 Native Client][SQL Server]Write on "VNBU0-136-4248-1255942421" 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-136-4248-1255942421:" 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 "DotnetDatabase" to VIRTUAL_DEVICE='VNBU0-136-4248-1255942421' 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\Veritas.Database.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 2035(2035) seconds.
INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\Veritas.Database.bch>:
<0> operations succeeded. <1> operations failed.
INF - The following object(s) were not backed up successfully.
INF - DotnetDatabase
10-19-2009 02:15 PM
10-19-2009 08:23 PM
10-25-2009 09:52 PM
10-25-2009 10:54 PM
1. Change the log on to account in service and restart service.(optional)
2. After changing log on account(in services) prepare new script using Backup Sql Server objects(from client) for all the failed db's and start backup from master server using this newly prepared script.
04-29-2010 02:15 AM
04-29-2010 04:41 AM
04-29-2010 07:46 AM
04-29-2010 09:30 AM
04-30-2010 08:06 AM
04-30-2010 09:00 AM
05-04-2010 09:05 AM