While executing the below query to find the results getting the below error:
Do I need to use cast/convert statement?
Msg 8117, Level 16, State 1, Line 1
Operand data type nvarchar is invalid for sum operator.
select sum(database_name), backup_size/(1024*1024),
backup_finish_date,type from backupset where type ='D'
--order by backup_finish_date asc
group by database_name