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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s