Recently I was working on a SharePoint 2010 server where a user was unable to open his My Site with an error  “Object Reference not set to an instance of an object”, Troubleshooting this error is altogether a different territory and I am going to write about it in another article soon 🙂 .  However in our case we resolved our issue by restoring the site with My Site backup available at the DPM server.

However, when we were trying to do the My Site recovery from DPM we kept getting the error “DPM was unable to attach the databases to the SQL instance”.

Unable to Attach Databases to the SQL Instance

Unable to Attach Databases to the SQL Instance



This is a known limitation when using Optimized Item Level Recovery (ILR) for SharePoint that uses clustered SQL servers, the work around is to do a non optimized recovery.

To disable Optimized ILR completely, use the following registry key on the DPM 201o server:

Key: HKLM\Software\Microsoft\Microsoft Data Protection Manager\Configuration\SharePoint
Value: DisableOptimizedILR

PS: The same solution is valid for DPM 2012


Hope this resolves issue at hand, start a new thread on our forum to report or seek help on another issue

The following two tabs change content below.
An automobile enthusiast at heart and computer geek by profession, started my Career with MS in 2005.Left Jobs and started Pledge Technologies (the parent company to Grishbi) back in 2009.We have been providing IT consulting to various Small and Medium businesses across US and UK since then.Our company specialises in Microsoft Server technologies like AD, Exchange, the rest and with numerous Office 365 migrations under our belt, we quite an expert with that too. Whatever we learn in our day to day life, we share it back on Grishbi as a Thank for all the love and support our customers have given us.
%d bloggers like this: