my personal blog about systemcenter

Archive for September, 2011


repost from :

One of the many new features in Data Protection Manager 2012 Beta 2 is the ability to host multiple Data Protection Manager SQL databases on the same SQL server.



Locally on the SQL server the DPM install wizard needs to be run or the sqlprepinstaller , SQL 2008 R2 Update 4 or up are supported

Install is almost instant and leaves the DPM Remote SQL Prep files in





On the Data Protection Manager Server we need to start the installer



And we need to set “Use an existing instance of SQL Server” and type in credentials administrator access on the SQL server and Windows machine , and “Check and Install”

SQL Browser needs to be started on the remote server this is not enabled pr default


After prereq check have completed its next for install


And we can see that the database files are greyed out due to selection of remote sql install.


And the installer does it job (not the SQL Server 2008 R2 is already installed)



And as always the color of DPM is Green for successful install , and off to a quick repeat on a different DPM server


And we can see that one Data Protection Manager config database have been created pr DPM Instance


Microsoft recommend dedicated SQL server for hosting the database , granting full access for the computer account for each DPM server helps with arguments against this.


repost from :

One of the many new features in DPM 2012 is the ability to restore single files from a vhd backup , this feature was available in DPM 2010 (ref : but that required a dedicated hardware unit for running DPM this have been improved in DPM 2012 so there is no longer a requirement for that , so we can run DPM from within a Hyper-V guest and still be able to recover single files from full vhd backups.

This can help reduce the hardware cost in a distributed environment where we have the Tape drive located centrally but still want to be able to do quick restores locally.

Download link for beta 2


We need to start with setting up a protection group , so lets select a server through the Hyper-V Cluster , and as you can see the DPM10 we are sitting on now is running within the same Hyper-V Cluster


And name our protection group , dpm is running virtual so there is no tape drive attached so we only have the disk option.


and we will stick with the defaults just for this test


and we need to allocate some space


And we will replicate the data now so we have something to recover from.


And lets create the group.


and as always success and DPM goes hand in hand


And in our running jobs we can see the first replica being created.


Sadly there is no hardware VSS in the lab so we need to live with redirected access until the backup is done , Microsoft please consider to enable the hardware VSS provider for your iscsi server to work with DPM.


And we have a backup to restore from


When you go to recovery and drill down to the VHD , Windows driver installer will pop up


And there will be a new storage HBA installed


and when to drill down again you can see the drive being inserted


the drive is visible in diskpart


and from the disk administrator but should not be touched from other than the DPM admin interface


and lets go back to drilling down the interface


Until we get a single file to restore


Recovery of single items needs to be recovered over the network to a machine with a dpm agent installed


or as here the dpm server itself.


and we are ready to restore.


Small file so recovery is almost instant , one more reason to love disk to disk backup


And we have the file restored.

This was a short intro to one of the many greater features in Data Protection Manager 2012 beta 2.