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

[EPETERS (Eric Peters)]

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,

Eric

[Mark_Wonsil]

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

• SQL Script to update URLs
• DB Refresh Rules of Thumb
• Automating custom object promotion (Jenkins, Chef, ...)

[John_Mitchell]

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.

dbatools

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