You want to find and obtain the size of the completed backup for Microsoft SQL Server. You might want to follow the following command,
select ctime "Date" , decode(backup_type, 'L', 'Archive Log', 'D', 'Full', 'Incremental') backup_type, bsize "Size MB" from (select trunc(bp.completion_time) ctime, backup_type, round(sum(bp.bytes/1024/1024),2) bsize from v$backup_set bs, v$backup_piece bp where bs.set_stamp = bp.set_stamp and bs.set_count = bp.set_count and bp.status = 'A' group by trunc(bp.completion_time), backup_type) order by 1, 2;
The output as below,
Date BACKUP_TYPE Size MB
--------- ----------- ----------
08-DEC-22 Archive Log 113.31
08-DEC-22 Full 127785.23
09-DEC-22 Archive Log 402.2
09-DEC-22 Full 128047.8
10-DEC-22 Archive Log 390.72
10-DEC-22 Full 128060.13
6 rows selected.
