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”.
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
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
Latest posts by Shishir Chandrawat (see all)
- Exchange 2010 Std: Mailbox server has reached the maximum database limit of 5 Error RcrExceedDbLimitException - December 12, 2016
- Exchange 2010: Unable to add Mailbox Database copies on DAG member servers, Error: An error occurred while processing a request on server - December 12, 2016
- Unable to Mount Microsoft Exchange DAG Database, Error: Failed to determine the mount status of the active database copy - December 12, 2016