Automate Production DB Import into Test Server

Hi Everyone,

I was reading through some forum posts on support.powerschool.com and I found a few references to a script that imports the production DB into the test server on a nightly basis. I am looking to do something similar but want to run a script that imports the Friday night backup every week into my test server.

I have been trying a few different things and before I push too far into writing a .bat file to do this I wanted to see if anyone has a script already created. Please email me if you have any info.

Thanks,
Jon Mall
jmall@ucfsd.net