When you use the Dpmsync.exe utility to restore a Microsoft System Center 2012 Data Protection Manager (DPM 2012) database, the restore operation fails and you receive the following error message:
Error ID: 470
DPM database is not present in the instance of SQL Server. Check that the DPM database is present in the given instance of SQL Server.
Detailed Error: Invalid object name 'dpmdb.dbo.sysfiles'.
For all the details including the cause and a resolution, please see the following: