Well, we've come across some daft bugs in our time, but this one has to be given the award for the most vague and stupid.
One of our Data Protection Manager 2012 Servers stopped working overnight with the an error stating:
Connection to the DPM Service has been lost
Review the application log to verify the services are running and it lists the DPM & SQL Services.
You will also find errors in the system log with Event ID 7034 The DPM Service has terminated unexpectedly, it has done this x time(s)
Also the DPM console would not open claiming the services are not running.
Following Gregg's EMC blog which talks about a similar issue in DPM 2007 http://consultingblogs.emc.com/greggrobertson/archive/2011/01/14/microsoft-dpm-fails-with-event-id-7034-quot-the-dpm-service-terminated-unexpectedly-it-has-done-this-x-time-s.aspx and involves backing up the database, accessing it with SQL Management Studio and running a script we started down this route.
We started by backing up the database running DPMBackup.exe in a command prompt.
- Browse to C:\Program Files\Microsoft System Centre 2012\DPMDPM. Hold down the shift key and right click on the bin folder and pick Open command window here.
- In the command windows type DPMBackup -db and allow the script to complete
- Once complete open SQL Management Studio and browse to the DPMDB database. Strangely we found it in SINGLE_USER mode! Weird?!
- Right click on the database, select Properties, and select Options on the left of the Database Properties Window. Under the State section on the right pane, go to Restrict Access and change from SINGLE_USER to MULTI_USER and click OK
You will now be able to restart DPM services and the console will open as normal, how this database got into this state is a right mystery.
Hope this saves some stress