command to restore SQL database

To restore database I run DpmSync -restoreDB -DpmDbLoc C:\Temp\DPMDB.bak and receive Error ID 457 Invalid command line arguments were specified
Who is Participating?
PadawanDBAConnect With a Mentor Operational DBACommented:
I don't think you're supposed to restore the DPM database separately (i am pretty sure DpmSync does that, per the first link I posted to the MS KB).  I would, of course, hang on to all the backups (that way you can always reinstall the DPMDB database if you need to), but I would try deleting the DPMDB database and use just that DPM2012 SP1 backup to DPMsync and see what happens.  I would have hoped there would be some more descriptive errors to handle this if it is indeed the issue.

edit:  i think that may be the issue, check here:
PadawanDBAOperational DBACommented:
I am pretty sure it's just: DpmSync -restoreDB -DbLoc C:\TempDPMDB.bak (src:
vadimmikhalAuthor Commented:
now vereytime i try to run this command,DpmSync.exe stop working
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

PadawanDBAOperational DBACommented:
Any error information in the event logs ?
vadimmikhalAuthor Commented:
Event ID 1001

Fault bucket , type 0
Event Name: CLR20r3
Response: Not available
Cab Id: 0

Problem signature:
P1: dpmsync.exe
P2: 1.0.523.0
P3: 50ad9639
P4: Microsoft.SqlServer.SmoExtended
P6: 4fec7a1c
P7: 177
P8: 8b

Attached files:

These files may be available here:

Analysis symbol:
Rechecking for solution: 0
Report Id: a0abfedb-209a-11e3-93f7-70f3950e45de
Report Status: 2048
Hashed bucket:
PadawanDBAOperational DBACommented:
What version of DPM are you using?  If it's 2007, take a look at this kb at microsoft:

This one may be unrelated, but I did come across this item relating to the DpmSync utility:

If none of the above, I do have a few housecleaning questions: does the DPMDB database already exist in the instance (if yes, can you try renaming it), do you have the Client Tools SDK installed on the SQL server instance, is the SQL Server instance on the same server as DPM, and finally what version of DPM is this?
vadimmikhalAuthor Commented:
This is DPM 2012 SP1 (upgrade from server 2008R2 to server 2012)
SQL instance is on the same server as DPM
DPM 2012 SP1 was backed up
Server 2008R2 was upgraded to Server 2012 (clean install)
After upgrade, DPMDB was restored from backup using SQL Server management studio (upgrade was successful)
After restoring DPMDB,I ran DPMsync -sync and it failes
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.