MODIFY FILE encountered operating system error 112 (There is not enough
space on the disk.) to expand the physical file.
Could not adjust the space allocation for file 'design_Data'
RESTORE DATABASE is terminating abnormally

I got the following message while trying to restore a backup of the live
database to the database. My understanding is that this problem
arises due to the disk space allocated to the database. i tried truncate log files too.

When I look at the size of the live database, the mdf file is 4513280 KB and
the log file is 16576 KB. Paritions on the hard disk are as follows C:
24.5 GB Free D: 11 GB Free F: 16.5 GB Free.

Can anyone tell me how I can overcome this problem and how it might be
prevented in the future?

Many thanks,