Re: SQL Query Challenge
2004-03-18 15:43:47
Jack,
You can try this
Last nights Backup
select Entity,Successful,Bytes,Examined,Affected,Failed
from summary
where activity='BACKUP'
and cast((current_timestamp-start_time)hours
as decimal(8,0)) < 24
order by Entity'
then after you run the backups again try this
what happened in the last hour
select servername,nodename,date_time
from actlog
where (cast((current_timestamp-date_time)hours as integer)>1)
|
|
|