Hi Leon,
Thanks for the reply.
We have identified the issue. The DPM service was not starting after DB restore because the install rollup was different than the one earlier.
Identified the DPM rollup version using below query
Select distinct MajorVersionNumber,MinorVersionNumber ,BuildNumber, FileName FROM dbo.tbl_AM_AgentPatch order byMajorVersionNumber,MinorVersionNumber,BuildNumber
we have reinstalled the DPM application with proper rollup, restored the DB using SQL management studio, run DPMSync -Sync command. The DPM service is now started, console opened normally and showing all the recovery points.
Thanks
Sunny