Showing posts with label dbo.tbl_DLS-GlobalSetting. Show all posts
Showing posts with label dbo.tbl_DLS-GlobalSetting. Show all posts

Tuesday, February 23, 2016

Troubleshoot DPM Service unable to start, unable to remove agents and 9xx-errors in the Event Viewer

Hi,
Quick post on one thing to check if you are expericening the following symtoms/issues on a DPM-server:
  • DPM AccessManager Service not starting 
  • DPM Accessmanager Service fails to start
  • DPM service not starting or having trouble restarting
  • Msdpm cannot be found
  • Unable to remove agents
  • Various 9xx errors in the event viewer

Resolution:
*** Important! Always create a backup of the DPM-database before doing any changes! ***
  1. Open SQL Management Studio on the dpm server and connect to the instance of your DPM sql engine
  2. Go to DPMDatabase (in my case: DPMDB_2012) > Tables > dbo.tbl_DLS_GlobalSetting
  3. Choose "Edit the top 200 rows" of that table and you will find a property called: DBRecovery
  4. The value should be 0, sometimes while doing dpmsyncs and other attempted repairs to dpm, this will be set to 1 and never change back to 0. 

I hope this will help someone with their troubleshooting!
//Markus