PowerShell is certainly the answer here.. run the script as a scheduled task.. I usually run them on a separate server, and have them email me any errors when complete.
See below.. this should get you started. You'll obviously want to test this in a…