12-19-2014 02:02 AM
Hi,
Need help on the issue.
SQL Backup is getting partially successful, this is skipping a single database.
Master Server : Solaris
Client : Windows 2003
Script :
OPERATION BACKUP
DATABASE $ALL
SQLHOST "gbbrf-sqtopcat"
NBSERVER "SLNX-NBUMST-LONSRD-PROD.ESC.LON.DLH.DE"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
VDITIMEOUTSECONDS 1800
ENDOPER TRUE
12-19-2014 03:08 AM
well enable db logs on client
also check the permissions
Article:TECH43512 | | | Created: 2009-01-16 | | | Updated: 2013-10-28 | | | Article URL http://www.symantec.com/docs/TECH43512 |
12-19-2014 04:08 AM
What other logs are required ?
I think its not an issues with the permissions, as this is an intermittant issue.
12-19-2014 04:32 AM
There is a bug in the netbackup where dbbackex remains active even after backup completion. So kindly check the dbbackex process in the client and kill those process
01-06-2015 06:44 AM
I am late to this discussion but it seems that nobody even tried to have a look at the logs provided.
It seems that backup for db cognos_content is failing after 100% of db was read and sent to server.
20:01:40.500 [5932.4816] <4> CODBCaccess::LogODBCerr: INF - SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]100 percent processed.>
There is not enough info in the level 0 log to say what went wrong.
All we can see is a network-related error (but we can see that all other db's are backing up fine):
20:01:41.719 [5932.1524] <16> writeToServer: ERR - send() to server on socket failed:
Please increase logging level for this client to a 3 and then run a backup for this client only.
Before you start, please rename exist dbclient log so that we have a 'clean' log for this db only.
Other logs that need to be checked on the SQL client:
SQL errorlog
SQL VDI log.
Other NBU logs that may be needed:
On master: bprd (restart NBU after folder is created)
On media server: bpbrm and bptm.
One more thing (as we can see that master is on a different network to the client):
Is there a time difference between the client and the master?
The difference should not be more than a couple of minutes.
01-06-2015 08:47 PM
You didn't tell us your Netbackup version... but in your dbclient logs, I can also see the following error:
20:01:42.031 [5932.1524] <32> CDBbackcat::GetSysBackupTimes: ERR - No rows found in SQL request <SELECT replace(convert(varchar, s.backup_start_date,111),'/','') + replace(convert(varchar, s.backup_start_date,108),':',''), replace(convert(varchar, s.backup_finish_date,111),'/','') + replace(convert(varchar, s.backup_finish_date,108),':','') FROM msdb.dbo.backupset s inner join msdb.dbo.backupmediafamily m ON s.media_set_id = m.media_set_id WHERE s.database_name = 'cognos_content' AND m.physical_device_name = 'VNBU0-5932-4816-1418932820' ORDER BY s.backup_finish_date>. 20:01:42.031 [5932.1524] <16> ReadFromVirtualDevice: ERR - Internal error. See the dbclient log for more information.
This is consistent with a known bug as described in: http://www.symantec.com/docs/TECH204104.