I have had to rebuild a 2012 Server w/SC DPM2012 Sp1. I followed this process to the tee: http://technet.microsoft.com/en-us/library/bb808877.aspx In trying to do the restore command ON the remote SQL 2008R2 instance running on a Server 2008R2 physical box it immediately fails with this pop-up from CLR20r3 as well as the error indicated in the CMD prompt box
When run on DPM server this error is generated:
Even thought the error indicates login error it is NOT the case as the indicated login has no problem accessing all the other databases on the SQL server. After hours of Googling it is well know THAT same error will appear when the database itself is unavailable, which IS the case. It doesn't get restored.
I'm LOST would love a solution.................. I'm imagining restoring the db from within SQL by doing a SQL restore will NOT work??? Or it WILL restore the db it just will have problems syncing with DPM 2012SP1