July 17, 2013 at 3:41 pm
Hi all,
I have an instance where there are 2 databases and it is backed up by Netbackup MS sql client directly to tape.
However, one of the database is failing when it runs on schedule, but when I manually backup through netbackup client, it works.....I was thinking if it's a permission issue and I checked the acct Netbackup is running on and it is Local System.....but the other db backup is running fine, so, I am not sure if it's a permission issue since it uses the same acct.
Someone asked me to check the Autosys scripts.....I am not very familiar with it.
If anyone have experience with netbackup plz advise.
Regards,
SQLisAwe5oMe.
July 17, 2013 at 11:58 pm
Can you post the error message from the logging/job history?
July 18, 2013 at 9:11 am
HanShi (7/17/2013)
Can you post the error message from the logging/job history?
Hi Hanshi, Here is some backup failure error I found....I have modified the error slightly to avoid the servername, dbname, etc.
See Error Log Below.
TIMESTAMP 20130716070005
MASTERSERVER 'NetbackupMasterServerName'
CLIENT Windows 'ServerName'
INSTANCE 'Servername\InstanceName'
DATABASE 'DatabaseName'
OPERATION BACKUP
OBJECTTYPE DATABASE
OPTION INCREMENTAL
STATUS -1
INFO Error in GetCommand: 0x80770004.
INFO An abort request is preventing anything except termination actions.
INFO Internal error. See the dbclient log for more information.
INFO Bad client VxBSAstatus 1 for pipe #0.
INFO ODBC return code <-1>, SQL State <37000>, SQL Message <3271><[Microsoft][SQL Native Client][SQL Server]A nonrecoverable I/O error occurred on file "VNBU0-9740-16452-1373933307:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).>.
INFO SQL Message <3013><[Microsoft][SQL Native Client][SQL Server]BACKUP DATABASE is terminating abnormally.>
INFO SQL Message <0><[Microsoft][SQL Native Client]Unspecified error occurred on SQL Server. Connection may have been terminated by the server.>
INFO Error found executing <backup database "DatabaseName" to VIRTUAL_DEVICE='VNBU0-9740-16452-1373933307' with stats = 10, blocksize = 65536, maxtransfersize = 65536, buffercount = 1, differential>.
INFO Error in DBthreads::dbclient: 6.
INFO The system cannot find the file specified.
INFO Error in VxBSAEndData: 6.
INFO The handle used to associate this call with a previous VxBSAInit() call is invalid.
ENDOPER TRUE
Regards,
SQLisAwe5oMe.
July 19, 2013 at 12:03 am
SQLisAwE5OmE (7/18/2013)
INFO The system cannot find the file specified.
The key here is the above line. It looks like the backupfile cannot be created. Verify the filepath and access permissions to that location. Check the filename of the backup for unallowed characters (like: /, \, ", *, :, ?, <, >). Also check if there is enough space to write the backup.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply