SQL-Backup-Statistik
SELECT sysdb.name, bkup.description, bkup.backup_finish_date, case when type=’D‘ then ‚** FULL **‘ when type=’I‘ then ‚DIFFERENTIAL‘ when type=’L‘ then ‚LOG‘ end as Backup_Type, (STR(ABS(DATEDIFF(day, GetDate(),(backup_finish_date))))) as ‚Days_Ago‘, ceiling(bkup.backup_size /1048576) as ‚Size Meg‘ , cast((bkup.backup_size /1073741824) as decimal (9,2)) as ‚Gig‘, server_name, sysdb.crdate ,datediff(minute, bkup.backup_start_date, bkup.backup_finish_date) as ‚Mins‘ ,cast(cast(datediff(minute, bkup.backup_start_date, bkup.backup_finish_date) as decimal (8,3))/60 as decimal (8,1)) … Weiterlesen