DPM 2010, copy database files to folder with powershell
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? :P