@ more AA6YQ comments below
+ In my view, making your local backup and recovery mechanism reliable should be your first priority.
Agree 100%; working on that and any recommendations are welcome.
@ SSDs are more expensive than rotating drives, but they are also more reliable. In dedicated backup service, however, a failed rotating drive (as you have now) is not fatal because the primary storage (ideally SSD) and the cloud backup service both remain intact, preventing a single-bit failure from causing data loss, Thus I would simply replace your failed rotating drive with one having plenty of capacity.