Option 1: Create the directory structure so that the restore operation can use the original installation path.
Option 2: Use SQL Server Management Studio to perform the restore of DPMDB.bak. Then, after the database is restored, run DpmSync.exe –sync from an administrative command prompt (Run As Administrator).
This problem may occur if the name of the restored DPMDB does not match the default DPMDB name that's mentioned in the error message. To verify this, look in SQL Server Management Studio for the DPMDB that was successfully restored, and determine whether the DPMDB name differs from the name that's shown in error ID: 454.
If the names do differ, use SQL Server Management Studio to change the name of the currently mounted DPMDB to match the DBName value that's noted in the error message:
- Expand Databases, and then select DPMDB.
- Right-click DPMDB, and then select Rename.
- Change the DPMDB name to reflect the name that's noted in the ID: 454 error.
- In SQL Management Studio, make sure that the user that's specified in the error message has sysadmin permissions under server roles and that DPMDB is selected under user mappings.
- At an administrative command prompt, run DpmSync.exe –sync.