Hi,
I'm trying to understand the contents of the summary table on our TSM
5.3.4.0 server.
When I do
select entity,failed from summary where activity='BACKUP' and
cast((current_timestamp-start_time)hours as decimal(8,0)) < 24 and failed>0
order by entity
I get a number of results.
However, when I check the activity log for the results of a certain MSSQL
server with
q act begint=-24 search=SQLSERVER
I get results like
10/17/2007 22:01:26 ANE4993E (Session: 475, Node: SQLSERVER) TDP
MSSQL Win32 ACO3002 Data Protection for SQL: full backup
of database Database from server SQLSERVER failed, rc = 1914. (SESSION: 475)
Why is this node listed in the summary table as OK, while it in fact failed?
Is this because the backup is initialized on the SQLServer through a task
scheduler command instead of by using the schedule settings on the server?
Kind regards,
Rick
|