DPM (Data Protection Management) - Anyone Familiar with using it with Powershell

• YSLGuru

  SSC-Insane

  Points: 21669

  More actions

  August 18, 2009 at 11:23 am

  #138160

  We use DPM 2007 for all of our backups from Files to DB to you name it. I deal with the SQL Server parts of our company and when it comes to DPM, the ability/flexability with restoring a previously backed up (or recovery point) is very narrow. You can use the provided GUI and while it works, there are limitations. You are supposed to be able to use Powershell with DPM but the problem is that

  a) Powershell is the 'Greek' of scripitng - meaning it's like trying to learn/understand Greek verses soemthing far easier like Spanish or French

  b) There aren't any clear & SIMPLE sample poewreshell scripts for DPM and it far from intuitive on how to build a Powershell script for DPM to do even somethings imple like restore a specific Backup/Recovery Point to a specified DB Server as a Specified DB Name, specifying a different file path & name for the data file & the log file from that of the source DB.

  Does anyone have or know of a sample Powershell script that will let you recover from DPM a database to a different server with different Name & file paths then thiose of the source DB?

  I'm looking for something along the lines of this Psudeocode example where you explictly specify the Recovery DB & point in time to recover as well as where to recover to (differes from source backup) including the file paths & names of the Data & Log file. The only default accepted is the logical file names. Each month we restore a copy of our LIve DB to a working backup we can test/develop against and the only way to automate this in DPM (short of paying for some third party app) is to use Powershell or at elast that's what I'm told.

  Any help would be greatly aprpeciated.

  Pseudo Code Example of desired scripting action:

  If DPM.Restore(RecoveryGroup='MyGroup';

  DB='MyDatabase';

  RecoveryPoint='2009.08.18 01:00:00';

  DestinationServer='NewServer';

  DestinationDB='NewDatabase';

  DataFile='D:\DATA\NewDatabase.mdf'; DataFileLogicName=DEFAULT;

  LogFile='D:\DATA\NewDatabase_LOG.ldf';

  LogFileLogicName=DEFAULT;

  ForceRestore='TRUE';) TRUE THEN

  ''Restore Sucessful'

  ELSE

  'Restore Failed'

  Kindest Regards,

  Just say No to Facebook!