SQL Script Assist - Auto Backup and Restore to Test Month End

Good Morning,

Sure I can piece it together, but wondering if anyone has a script they can share that:

Does a backup of Live
Restores to Test
Preferably Month End

Not sure if I missed anything…

Thanks in advance,


A search of the site brings up several discussion on this:

We just use a BAT script but there are a ton of PowerShell automation tools that you can use. If you want to see some great examples you can check out Drew Furgiuele sessions.

Also, Epicor has a PowerShell module that they have documentation for: Epicor.Ps.Erp Documentation

It sure looks like this is their preferred method of creating a backup: Epicor.Ps.Erp Documentation