Yes that was indeed the case. Recently, I had configured Frigate for motion detection on 8 cameras so the media folder was full of snapshots and video clips from motion detection.
Just had to exclude “media” folder from the backup and everything seems working fine now!!