Have a similar issue ... 2 courses in the 20+ (1 - largest 90+) Gig range kill automated backups.
So, the only way I've figured out is to use the backup.php in moodlecode/admin/cli/ and loop that php file through a courseids.txt file which list only the course ID's to backup via a bash shell script. Run from moodlecode/admin/cli/ as root user. Since you are Windows, powershell/batch files? OR think one can install GNU commands utilities ... like bash ... on Windows servers now.
courseids.txt looks like:
The bash shell script called 'nidobu' (non-interactive do backups) looks like:
echo 'This backups up ALL course IDs from list above.';
echo 'paused ...';
for i in `cat ./coursesids.txt`;
echo "Course ID in que: $i";
php ./backup.php --courseid=$i --destination=/path/to/where/you/want/backups/to/save/
echo '***** NEXT course. *****';
As with anything automated, good idea to make sure you have enough space where the backups are to go. *** Don't save the backups to the same disk/partition where your DB server resides. IF the drive fills up with backups, you run the risk of DB server not being able to function. When DB server runs out of disk space, you've got big problems. ***
One could cron job that and have it run in the background. With all courses, could be memory intensive AND take a long time (depending).
On server where it could be run:
wc -l coursesids.txt renders:
That's 1,246 courses.
'spirit of sharing', Ken