DPM 2010, copy database files to folder with powershell

[sch]

Hi! I am a total novice with powershell, but have been given the task by my manager to create a script wich selects the newest replica of a database in dpm, and copies the .ldf and .mdf files to an network share.

 

I have managed to scramble the commands wich always selects the newest replica. But i can't figure out what the command to select the files within that replica, and then copy them to the network share. Furthermore, they have to overwrite existing files everytime they get copied.

 

You can easily do this via the GUI, but the client who needs this setup wants it to be automated, as it has to be done once every 24 hours.

 

Does anyone have a script like this lying around, or could whip something up in a jiffy?

[irsprint84]

I dont understand why you re scripting this? you can do dpm database backup in dpm

[sch]

I dont understand why you re scripting this? you can do dpm database backup in dpm

 

Yes, but as far as i understand and see, you can't create and automated restore-job in the GUI. You have to do that by script? I did come across a script of something similar after i posted this thread, so i will try it out.