Upgrading DPM 2007 to DPM 2010
A customer is running DPM 2007 SP1 on a Windows Server 2003 with a Remote SQL 2005 database.
The customer want's to upgrade to DPM 2010.
In this post I will explain my upgrade plan and the issues I ran into.
Before starting the upgrade process, I realized there are some issues !
DPM 2010 needs Server 2008, and SQL 2008 !
After doing some research I decided to upgrade the OS to 2008 R2.
To do that, DPM needs to be uninstalled and reinstalled afterwards.
When reinstalling DPM 2007, I will install a local dedicated SQL database on the backup server. Database will be backed up from the remote SQL and restored in the dedicated SQL on the backup server !
Ready to start !
Backup DPM database
The first step is creating a backup of the DPM database. I used the following command to backup this database:
C:\Program Files\Microsoft Data Protection Manager\SQLPrepDPMbackup.exe –db –instanceName <instanceName>
I was struggling with this command due to a typo. I used the parameter -instance and not -instanceName. This gave the error "invalid parameter -db" which got me on the wrong track!
The backup file will be stored at C:\DPMBackup<instancename>DPMDB.bak
Upgrade the Operating System
I uninstalled DPM, and choose to retain data (IMPORTANT!), and started the update process from Windows Server 2003 R2 SP2 Enterprise (x64) to Windows Server 2008 R2 Enterprise. It took a few hours before this process finished, and a few small issues occurred. I need to install the HP PSP pack for Server 2008 R2 to update my drivers. And my network settings were gone. After re-configuring these settings, all network services were working except RDP. It wasn’t possible anymore to connect to the backup server via RDP. (click here for more information on how I solved this issue)
When reinstalling DPM with the dedicated SQL instance I ran into another issue. SQL installation went fine but the DPM installation itself failed because it could not start the SQL server service ! In eventviewer I got the following error: The SQL server (MS$DPM2007$) service terminated with service-specific error %%-2146885628
After adding the local MICROSOFT$DPM$Acct to the Local Administrators group, the service started and DPM installation succeeded !
I also installed SP1 and hotfix KB 968579 to have the same version number as the previous DPM installation. (Version 2.0.8836.0)
Restoring the database
I copied the backup from the remote SQL to the backup server. And restored this database into the new dedicated SQL using the following command:
DpmSync –RestoreDb -DbLoc D:<path-to-backup>DPMDB.bak
Synchronize the database: DpmSync –Sync
When opening the DPM console all my earlier protection groups and protection members are showing up! But they all need to be synchronized with a consistency check! While these jobs were running I noticed that every time I tried to open the Management Tab in the administrator console my DPM closes. No error appears ..
Being convinced a reboot would solve this issue, I waited till all consistency checks were finished.
But a reboot didn't solve this issue. I decided to start the DPM 2010 installation and deal with this error later.
Upgrade DPM 2007 to 2010
Upgrading to DPM 2010 was as easy as inserting the disk and going to the installation wizard.
Installation went without issues and my management tab issue was resolved to!
I did some backup/restore test afterwards and no issues appeared!