Tuesday, November 8, 2011

DPM 2010 Sql Instance Wont Start after failed SQL Service Pack Update

A customers DPM Server crashed today while in the middle of the installation of SQL2008 Service Pack 3. So when the server came back online the msdpm2010 sql instance would not start.

So when reviewing the event logs I could see the following.

event ,959 mssql$msdpm2010

The resource database version is 611 and this server supports version 662. Restore the correct version or reinstall SQL Server

The fix is quite simple. Take a copy of the DPM Databse which is located by default in C:\Program Files\Microsoft DPM\DPM\DPMDB

Then go to programs and features and select SQL 2008 , then uninstall/change and then repair. Point the repair wizard at the sql 2008 installation media and let it repair the SQL 2008 installation.Once complete , reboot the server and then will then be able to view your protection groups as before.

1 comment:

  1. That is really fantastic and exciting to read your thoughts as I have the same point of view on all the subjects. It is really awesome. Anyway, I need to download an free apps. Have you tried to download application virtualization from cameyo? They said it is great apps but I some complimentary for that site for sure. Thanks.