Here is the scenario:
Sharepoint 2010 , System Center Data Protection Manager 2012 , MS SQL 2012 .
When trying to backup the Sharepoint database , you get an error , and sometime it shows as OK , but when you click to recover the database , it automatically disappears.
Finally I figured out the issue (with some help from Microsoft).
Go to SQL server , you will find a service called DPMRA , it's running under the Local System.
But SQL 2012 doesn't give NT AUTHORITY\SYSTEM account the system admin role (this changed from SQL 2008 R2 and was never updated on the new procedure for installing DPM with SQL 2012)
To fix this:
1- Give NT AUTHORITY\SYSTEM account sysadmin,security admin and db creator roles on SQL 2012.
2- Refresh the agent from the management tab of DPM.
3- Try sharepoint backup.
I hope this helps.
