Need help on the issue.
SQL Backup is getting partially successful, this is skipping a single database.
Master Server : Solaris
Client : Windows 2003
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
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 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.
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.