Archive for the ‘DPM’ Category

System Center 2012 R2 is RTM..So What is New ?!!!

October 18, 2013 Leave a comment

As many of you already know System Center 2012 R2 release today and you can download from MSDN website. So this is a quick post about new features in each product


What’s New in VMM in System Center 2012 R2


What’s New in System Center 2012 R2 Operations Manager


What’s New in System Center 2012 R2 Service Manager


What’s New in System Center 2012 R2 App Controller


What’s New in System Center 2012 R2 Configuration Manager


What’s New in System Center 2012 R2 Orchestrator


What’s new in System Center 2012 R2 – DPM

Categories: DPM, Opalis 2012, SCCM, SCOM, VMM, VMM2012 Tags:

DPM 2012 Rollup Update 3 Failed to execute SQL string

November 30, 2012 6 comments

We faced that during our Private cloud update to SC 2012 SP1

trying to install Rollup Update 3 to DPM 2012 server we got this error

MSI (s) (28!F4) [16:08:33:788]: Note: 1: 2262 2: Error 3: -2147287038
ExecuteSqlStrings:  Error 0x80040e2f: failed to execute SQL string, error: The statement has been terminated., SQL key: sqlscript_KB2751230Fix.sql SQL string: insert into tbl_DLS_GlobalSetting
(PropertyName, PropertyValue)
values (‘ConsiderOfflineMediaToCheckOffsiteReady’, ‘1’)
MSI (s) (28!F4) [16:08:33:788]: Transforming table Error.

MSI (s) (28!F4) [16:08:33:788]: Transforming table Error.

MSI (s) (28!F4) [16:08:33:788]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (28!F4) [16:08:33:788]: Product: Microsoft System Center 2012 – Data Protection Manager — Error 26204. Error -2147217873: failed to execute SQL string, error detail: The statement has been terminated., SQL key: sqlscript_KB2751230Fix.sql SQL string: insert into tbl_DLS_GlobalSetting
(PropertyName, PropertyValue)
values (‘ConsiderOfflineMediaToCheckOffsiteReady’, ‘1’)


it seem that the update running a script which need to insert a property in a database table as this error state

ExecuteSqlStrings:  Error 0x80040e2f: failed to execute SQL string, error: The statement has been terminated., SQL key: sqlscript_KB2751230Fix.sql SQL string: insert into tbl_DLS_GlobalSetting

(PropertyName, PropertyValue) values (‘ConsiderOfflineMediaToCheckOffsiteReady’, ‘1’)

so we try to run a query on the Database to check this property value and found that its already exist with same value which prevent the update from continue updating the DB

Select * from tbl_DLS_GlobalSetting where PropertyName = ‘ConsiderOfflineMediaToCheckOffsiteReady’

so we backed up the database and delete this RAW from the effected table:

Delete from tbl_DLS_GlobalSetting where PropertyName = ‘ConsiderOfflineMediaToCheckOffsiteReady’

then the update went successfully 🙂

Categories: DPM Tags: ,

Hyper-V Backups Fail with Error 2155248001

One interesting case for hyper-V backup is logged there


“ I have several Hyper-V boxes where windows server backups are failing.

Error message number from event viewer is 2155348001.

If I shutdown or save the guests, the backup works. Host OS is Windows Server 2008 R2 with SP1 installed. Guests are server 2003 or Windows XP.

So far I have tried deleting all shadow copy snapshots from the host as well as making sure the guests have enough free space.

I have deleted and re-created the backup several times and tried several backup devices ranging from USB to iSCSI to adding a second internal drive array. Guests are also running the newest version of the guest additions.

I have one server where I was able to figure out which guest the backup does not like. If I pause or shutdown that one guest, the backup works with the other guest still running. At think the problem is somewhere in Hyper-V, but I am not sure where to look next.”



it was due to the timeout for VSS creation. Default is 10 min.



This article shows how to set it to something else. Increasing the timeout fixed the backup. On my server creating the snapshots took 10min 30 seconds.

Categories: DPM, Hyper-V, Hyper-V R2, Virtualization Tags:

Microsoft Looks to Third-Parties to Extend DPM 2010

June 22, 2010 2 comments


It’s a big week for Microsoft Data Protection Manager 2010 … even though it’s a month or more away from general availability.  At the Microsoft Management Summit this week, DPM 2010 was released to manufacturing, and i365 and Iron Mountain both made DPM 2010-related announcements that extend its capabilities.

Microsoft continues to make strides since joining the disk-based backup and recovery space with DPM 2006, adding features that have increased its appeal to Microsoft-centric buyers.  Among other things, DPM 2010 promises to:

  • Increase scale.  A single DPM server can protect 100 production servers (up from 30-40) and 80 TB of data, 1000 Windows clients, 2000 SQL databases, 40 TB Exchange databases, and 25 TB SharePoint farms.
  • Provide a single agent for all Microsoft workloads, including support for Windows 7, MOSS 2010, Exchange 2010, and SAP running on a SQL server.
  • Support Hyper-V on Windows 2008 r2, including support for LiveMigration scenarios with cluster-shared volumes, recovery of .VHDs to an alternate host, and VM-level backup with either VM-level or file-level recovery.
  • Protect connected or disconnected Windows clients with continuous backup (backup is performed locally until a connection/synchronization is possible), allowing data to be recovered locally and enabling end-user self-service restore.
  • Enable SharePoint farm-level protection with document-level restore, eliminating the need for a SharePoint recovery farm.
  • Replicate a DPM server off site to third-party cloud providers, such as Iron Mountain or i365.

Iron Mountain and Microsoft previously teamed up to deliver a cloud storage option for DPM 2007 customers over a year ago, allowing users to extend their data protection strategies with cloud-based copies for DR.  This week, Iron Mountain announced support for DPM 2010 and enhancements to Iron Mountain CloudRecovery—beefing up its scalability, streamlining DPM-CloudRecovery integration, and altering its licensing/pricing model to provide greater cost efficiency and predictability to subscribers.

i365 is partnering with Microsoft in a slightly different way. i365 is delivering an all-in-one hardware-software-cloud solution: Evault for System Center Data Protection Manager (EDPM).  The Dell server ships with both Microsoft DPM and Evault backup software accessed via a single user interface and with a unified policy engine.  Why both?  Since DPM is limited to protecting Microsoft’s operating system, hypervisor, and applications, EDPM allows Microsoft to address a wider audience—including Linux, UNIX, NetWare, IBM i, VMware, and Oracle users.  Optionally, the EDPM storage can be replicated to the i365 cloud—creating a more economically-feasible DR copy for mid-market and small enterprise companies.

Missing from Microsoft’s DPM 2010 strategy is any statement that the company will leverage its own cloud service capabilities in Windows Azure.  Will DPM be offered as software as a service (SaaS)?  Will Windows Azure cloud storage be used for DPM 2010 DR copies?  Stay tuned.

Windows 2008 Hyper-V R2 Update for DPM 2010

Hyper-V R2 Update for DPM 2010

Install those two Updates on Hyper-V R2 server:

KB975354 A Hyper-V rollup package dealing with parallel backups on same cluster shared volumes and VM’s hosted by different servers; Avoiding data truncation as a result of simultaneous backup of VM from host and from within virtual machine; properly restoring a VM with snapshots to another location

KB975921 You may be unable to perform certain disk-related operations after an exception when a hardware provider tries to create a snapshot in Windows Server 2008 R2 or Win 7.

Backup Agent Causes Unsupported Cluster Configuration in SCVMM

It was an interesting case on the technet forum. Hyper-V Cluster is existing and the administrator trying to backup it using CommVault.

Every time the administrator try to backup the VMs he got Unsupported cluster configuration in the VMM, because clustered resource group is not configured correctly.

Microsoft point to same in KB 958184 in that scenario:

Hyper-V virtual machine files, such as the configuration.xml file or .vhd files, are saved on a volume in Windows Server 2008.

This volume is mounted on a failover cluster by using a volume GUID.

This volume does not have a drive letter or a mount point assigned.

You try to back up these virtual machine files by using a backup application, such as System Center Data Protection Manager 2007.

In this scenario, the backup operations fail and the virtual machine files cannot be backed up.

This problem occurs because the file path is misreported in the writer metadata that is sent to the backup applications by the Hyper-V Management service (Vmms.exe). Therefore, backup applications cannot recognize the volume, and the backup operations fail.

To solve this problem you have to install the hotfix in KB 958184.


Why should you move to System Center Data Protection Manager 2007?

Here are the ten most valuable benefits that System Center Data Protection Manager (DPM) 2007 can provide to your business. It can be found on Microsoft web Site.

Unmatched Exchange, SQL, and SharePoint Functionality

DPM 2007 offers integrated support for advanced Exchange and SQL cluster configurations, shorter SQL backup windows w/o the need for compression, as well as advanced SharePoint data protection options.

Zero data loss Restores for Applications

DPM 2007 enables lossless recovery of Exchange, SQL, and SharePoint servers without the need for constant replication or synchronization by seamlessly integrating a point in time database restore with the existing application logs.

Host Based Virtual Server Backups

DPM 2007 includes support for host based backup of Windows Virtual Server guests. Using a single host based DPM agent to provide application consistent backups of any and all guests residing on a host. DPM can protect any operating system or application via this mechanism as long as they are running on a Windows host server.

Recover files in minutes instead of hours

A typical file recovery from tape takes hours and can be costly. The typical medium data center may have 10 to 20 or more recoveries per month. DPM enables the same recoveries in minutes, saving money for the business and time for IT administrators. Additionally, faster recovery keeps information workers productive because they spend less downtime waiting for their files to be recovered.

Eliminate the backup window of your production servers

Massive growth in storage capabilities has increased the time needed to back up file servers. At the same time, businesses face the requirement for 24×7 uptime and the fact that there is no good time to perform a backup. Because DPM moves only the byte-level changes of the file servers it backs up, it effectively eliminates the downtime required to back up your file servers. Customers never have to plan for such “backup windows” again.

Enable users to perform their own recoveries

Recovery and backup processes generally involve multiple administrators, each having unique expertise, adding to the data management total cost of ownership. Corporations collectively spend billions of dollars annually on recovering lost data. DPM solves these problems by enabling self-service user recovery, which lets users access and retrieve files directly within Microsoft Windows XP and Microsoft Office XP applications without administrator intervention, thereby lowering administrator costs and increasing productivity.

Seamless Media Integration

DPM 2007 features seamless integration between disk and tape media, including an intelligent UI that abstracts the operator from the need to separately manage disk and tape media, an integrated restore experience for both disk and tape, and rich media management functionality.

Advanced Data De-Duplication Technology

Patented filter technology reduces the volume of full backups by as much as 90 percent in typical organizations, saving disk space and reducing full backup time from hours to minutes. VSS point in time snapshots further reduce the disk volume required, while Express full backup images increase number of available restore points which can be captured.

Remove tapes from branch offices and centralize backups at the data center

Today, the primary way to protect remote servers is for branch office staff to back up data to expensive removable media, such as data tape cartridges, and then manually transport the media to an offsite storage facility. Tape restores within this configuration can be expensive and slow. DPM deploys agents on the remote file servers to send the data back to the central data center where it can be more securely backed up by one IT administrator.

Use advanced functionality at low cost

Because DPM is part of the Windows Server System, it contains tools that are already in your server software, such as Microsoft Management Console (MMC) and Windows Explorer. IT administrators are already familiar with these tools, which reduces training costs. Along with the comprehensive report functionality included with the product, DPM can also upload all of its reports and alerts to the Microsoft Operations Manager console.

Categories: DPM Tags: ,
%d bloggers like this: