my personal blog about systemcenter

Archive for September, 2011

 

repost from : scug.dk

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.

 

image

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

image

 

 

image

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

 

image

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

image

After prereq check have completed its next for install

image

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

image

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

 

image

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

image

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

image

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 : scug.dk

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 : http://scug.dk/blogs/dataprotectionmanager/archive/2010/08/29/restoring-single-files-within-hyper-v-guests-protected-with-data-protection-manager-2010.aspx) 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 http://www.microsoft.com/download/en/details.aspx?id=27216

clip_image001

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

clip_image002

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

clip_image003

and we will stick with the defaults just for this test

clip_image004

and we need to allocate some space

clip_image005

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

clip_image006

And lets create the group.

clip_image007

and as always success and DPM goes hand in hand

clip_image008

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

clip_image009

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.

clip_image010

And we have a backup to restore from

clip_image011

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

clip_image012

And there will be a new storage HBA installed

clip_image013

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

clip_image014

the drive is visible in diskpart

clip_image015

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

clip_image016

and lets go back to drilling down the interface

clip_image017

Until we get a single file to restore

clip_image018

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

clip_image019

or as here the dpm server itself.

clip_image020

and we are ready to restore.

clip_image021

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

clip_image022

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.