Archive for the ‘Data Protection Manager’ Category

DPM Installation Error ID:820

Saturday, April 19th, 2014


When you install DPM 2010, right after the prerequisites  verification you receive an error  “Verify that Windows Management Instrumentation (WMI) Service is running. if…


in order to fix this issue, you need to reinstall WMI , this is how to do it

From an elevated Command Prompt

1. Disable and stop the WMI service.

sc config winmgmt start= disabled

net stop winmgmt

2. Rename the Repository folder under C:\Windows\System32\wbem to Repository.old

3. Run the following commands.

Winmgmt /salvagerepository %windir%\System32\wbem

4. Re-enable the WMI service and then reboot the server to see how it goes.

sc config winmgmt start= auto

Microsoft Azure Brazil South region is now in public preview.

Thursday, April 17th, 2014



DPM 2012 R2 Support Windows 2003 server

Thursday, April 17th, 2014


Don’t be surprise , DPM 2012 R2 doesn’t support Windows server 2003 ,   the rollup update is coming shortly and it will fix the issue.

I know if Shreesh said that it will happen :)


ldm threshold reached in DPM

Thursday, April 17th, 2014


The Issue started with the ldm threshold reached and we had to delete all the protection group and recreate then.

Due to this mass deletion of protection group. The pressure on the garbae collection job mounted as it had to delete lot of objects from sql database.

Now whenever the garbage collection job ran it increased the size of the tempdb which would consume almost all the space on the drive.

In order to find what query the garbage collection gets stuck we used this script.


the result Was:


Ran the garbage collection job along with this script and waited for tempdb to grow abnormally.

We got following output from the powershell script.


to fix the issue :


A huge credit to Abhishek   from the DPM Support Team

this is just a snapshots , from the resolution , if you get this error , don’t try to run the query on your own, i really recommend to contact MSFT support

DPM 2012 R2 Installation ERROR

Thursday, April 17th, 2014


DPM 2012 R2 doesn’t come anymore with SQL server , you either have to install an instance of SQL server in the same Machine , or use a remote SQL server to host the Database

During  the  installation of DPM 2012 R2 you may receive the following Error


the cause of the error that DPM  need to have reporting server with HTTPS configured , in order to resolve this issue you need to Configure SSRS with HTTPS ()


DPM Backup Summary Report

Wednesday, April 9th, 2014

Another clever work around for reporting from Steve

available at the Gallery :

The DPM Backup Summary Report is a free SSRS based report that you can load in your DPM environment. This report works with DPM 2010 and DPM 2012/R2. For now the report is only for disk and tape based backups. In the future we are looking to extend this in the future to show online (Azure) as well. The features and data points contained in the report are:

  • Ability to select day, week, month (Time range)
  • Ability to select a single server or many
  • Ability to select a single protection group or many
  • Ability to select disk, tape or both backup type
  • Summary of the backup success and failures with a percentage of the successes (Success Rate/SLA)
  • Health trend of backups (day, week, month)
  • Backup detail including:Individual data sources (What was actually backed up)
    •      The status including the error (if there is an error)
    •      Date and time the backup was created
    •      How much data was transferred during the backup
    •      Total time it took to backup to complete

More information about the report here:

Screenshot of the report:

Scaling out protection for virtual machines

Wednesday, April 9th, 2014

Since DPM 2012 SP1, you can scale out protection of Hyper-V clusters. The new scale-out feature removes the limit of a one-to-one relationship between a Hyper-V cluster and a DPM server, and the DPM protection agent that runs on a virtual machine can attach itself to multiple DPM servers. Therefore you can add the virtual machine to a protection group on any of the recognized DPM servers. Note the following:

I found  that a lot of folks don’t know about this feature , This feature is only available for virtual machines that are hosted on servers that are running Windows Server 2012.

Deployment scenario :

you have 2 DPM servers (DPM1, DPM2) one large Cluster comprised of two nodes ,

Scale out deployment for DPM

the Steps to protect the Cluster using DPM1 and DPM 2 are

1- Deploy DPM protection agents : from DPM 1 install the agent using the GUI

2- Connect DPM2 to Node 1 and Node 2 using the following command

SetDpmServer.exe Add –dpmServerName DPM2

3- Attached all the VMs to DPM 2  either using power shell cmd-let or the GUI the
Attach-ProductionServer.ps1 DPMServerName nodeN <user name> <password> <domain>
Or use DPM’s administrator console, management, Agents, click “Install” and select the “attach agents” as shown below

By following the above steps, all DPM servers are connected to all nodes on the cluster

TechEd 2014 North America

Wednesday, April 9th, 2014


Yes , I am presenting at TechEd 2014 , Shereesh and I will be talking about protecting large Private cloud,  using DPM , please come an listen to this presentation it is demo driven session


New SCOM DPM Dashboard Download Link

Wednesday, April 9th, 2014

From Steve’s Blog

A company named AIO Technology published a SCOM DPM dashboard a while ago. They recently removed it as they no longer offer this. I was the one that built this dashboard. I am posting about it here for anyone that may be looking to download it. You can now find this on TechNet Gallery here: 

Information about the dashboard:


This dashboard shows the overall health of your Data Protection Manager (DPM) backups. It includes all DPM servers in your environment in a central location. Great for daily spot checking of your backup health and getting to the root of any problems faster.

Installing is as simple as importing into your Operations Manager (SCOM) server. You do need DPM management packs and central console deployed to your SCOM before installing this dashboard.



  • Centralized health of all DPM servers
  • Protection Group health aggregate
  • Protected Data Source health aggregate
  • Storage Pool health aggregate
  • Tape/Tape Library health aggregate

Monitor SQL Availability Groups Using SCOM

Monday, April 7th, 2014

last year Microsoft released an updated Management for SQL Server , this MP was update to monitor Always on and SQL server 2012.

I found that SQL server 2012 is missing a lot of monitoring and alerts for Always On and its replicas.

in this blog , i will demonstrate how to use the latest SQL server MP to monitor SQL server and specially Always On

  1. Import SQL server Management Pack (Administration-> Management Packs –> right click and select Import MP—> Click Add from Catalog): make sure to choose version SNAGHTML3d9a9b83
  2. In SCOM Monitor Tab expand Microsoft SQL Server MPimage
  3. Management Pack Inventory :
  4. Monitor Performance for AlwaysOn Availability Groups (AG):

As I mentioned , there are a lot of monitors and rules to monitor Always On Availability Group In this management pack ,  I will choose only the most common rules that reflect the AG health

  1. The size of the log send queue on this replica: that Indicates the amount of log records in the log files of the primary database that have not been sent to the secondary replica,
    1. the rule name that monitor the log send queue is Log Send Queue Rule, the default Frequency to check is 900 sec – 15 min , I always recommend to override it 5 min = 300 sec ,
    2. To override : Go to Authoring –> Rules –> in the  search look for Log Send Queue Rule
    3. Right click and Choose override , Change the Frequency to 300 instead of 900
    4. now  when you go to Management pack SQL Server -> AlwaysOn High Availability –> Database Replica Performance->  and select Log send Queue for your replica , ideally you want always to see log send queue equal to zero , that means no log records are queued up image
    5. How to Alerts:You have to create a custom monitor based on a static threshold , the threshold should be Zero , that means , if the log send size is over  zero for N Consecutive sample raise an alert where N is the number of samples that SCOM collect, in our case ,N = 2
  2. imagein the general Tab , Type the name of the monitor, select Availability Group in the monitor Target  and leave the Parent Monitor (don’t uncheck Monitor is enable  )imagein the performance Counter  the easiest way to Click on select and choose the Perfmon counter “Log send Queue”image


In the Configure Health Change the Condition false to  Critical , and the Condition True to health and click next and finish


how do you Check that all is setup correctly :

Go to SQL MP , Availability Group , right click on your  AG , then open the health explorer , in order to receive alerts , you need to subscribe to this monitor


in the next blog I will talk about another rule in SCOM to continue monitoring your AG