Goal: Nightly DPM 2010 restore from clustered SQL Production database to overwrite Production Reporting Database on same server.
I know this cannot be done via DPM 2010 GUI and needs to be approached via DPM's Powershell Cmdlets. I'm just getting stuck in the forest of cmdlet syntax. I'm not worried about how to schedule that (I'll just use task scheduler), I just need
to figure out how to finish this script.
Here is where I am at so far (I know I have a bit to go still). Any help would be apprecaited:
$pg = Get-ProtectionGroup -DPMServername <SERVER NAME> #Set dpm server
$ds = Get-Datasource - ProtectionGroup $pg[x] # Get SQL Data protection group (x=protection group position in array)
$rp = Get-RecoveryPoint -Datasource $ds[x] # Get SQL Database to restore from (x=database position in array)
$rp[-1] # Returns lastest recovery point for SQL Database to be restored from
so now that I have the recovery point for the source Database, how do I go about overwriting a different destination database on the same server and instance? I think i have to use the following Cmdlets, but I need to nail down the syntax and get this
completed asap (reminder: clustered instance of sql):
View Complete Post