We recommend that you install a new instance of SQL Server 2008 instead of upgrading an existing instance of SQL Server. For information about how to install a remote instance of SQL Server 2008, see Installing a Remote Instance of SQL Server 2008.

Preparing to Upgrade to DPM 2010

Before you upgrade, make sure that the user installing DPM 2010 is a member of the following:

  • Administrators group on the remote instance of SQL Server 2008.

  • Sysadmin fixed server role.

  • Sysadmin on the remote instance of SQL Server 2005 (hosting the DPMDB for DPM 2007 SP1).

To prepare to upgrade to DPM 2010

  1. Identify which instance of SQL Server that DPM 2007 SP1 is using (from the “i” button on the DPM Management console).

  2. Connect to this instance using SQL Management Studio.

  3. Right-click the database, point to Tasks, and then select the Backup sub task.

  4. Connect to the instance of SQL Server 2008, and then restore the database to this instance.

  5. Right-click databases.

  6. Select Restore database.

  7. In the To database box, enter DPMDB.

  8. In the From database box, enter the DPMDB backup location.

  9. Select the backup sets, and then click OK.

Before you begin the Upgrade

Before you begin the upgrade, verify the following:

  • The SQL Server Browser service is running.

  • If a firewall is enabled, an exception is created for SQLServer.exe.

  • Remote connections are enabled on the remote instance of SQL Server.

  • DPM Support files (SQLPrepInstaller) are installed on the remote instance of SQL Server.

Upgrading an x64-bit DPM Server using a Remote Instance of SQL Server

Note the following when upgrading:

  • You must be logged on to the DPM server using a domain user account that is a member of the local administrators group.

  • If you are installing DPM from a network share, browse to the installation share, and then double-click Setup.exe in the root folder of the share.

  • Upgrade steps should indicate that the user has to delete the V2 database after v2 install is complete.

To upgrade an x64-bit DPM server using a remote instance of SQL Server

  1. On the Microsoft System Center Data Protection Manager 2010 screen, click Install Data Protection Manager.

    DPM will prompt you to remove the earlier installation of Powershell 1.0. After removing Powershell 1.0, click Install Data Protection Manager again.

  2. On the Microsoft Software License Terms page, review the license agreement. If you accept the terms, click I accept the license terms and conditions, and then click OK.

    After you click OK, DPM installs the Visual C++ Redistributable 2008 package and Microsoft .NET Framework 3.5 SP1 if they have not already been installed.
  3. On the Welcome page, click Next.

    DPM begins a prerequisites check for all required hardware and software.

  4. On the Prerequisites Check page, wait while DPM Setup checks the system to verify that it meets the software and hardware requirements.

    If all required components are present, DPM Setup displays a confirmation. Click Next to continue.

    If one or more required or recommended components are missing or noncompliant, Setup displays a warning or error message.

    On the Prerequisites Installation page, DPM setup installs any prerequisite software required for setup. The DPM Setup Wizard will indicate if a restart is required to complete the installation. If a restart is required, restart the DPM server and start DPM Setup again.
  5. On the Product Registration page, click Next.

  6. On the Installation Settings page, in the DPM Program Files section, the installation location will default to the installation location of DPM 2007. This location cannot be changed.

    On the Installation Settings page, in the SQL Server settings section, if DPM 2007 is installed with a remote instance of SQL Server, this setting cannot be changed. DPM 2010 will request a new instance of SQL Server 2008. For more information about providing a new instance of SQL Server 2008, see To prepare for upgrading to DPM 2010.

  7. On the Security Settings page, specify and confirm a strong password for the restricted MICROSOFT$DPM$Acct and DPMR$<computer name> local user accounts, and then click Next.

    For security purposes, DPM runs SQL Server and the SQL Server Agent service under the MICROSOFT$DPM$Acct account, which DPM Setup creates during the DPM installation. To securely generate reports, DPM creates the DPMR$<computer name> account.

  8. On the Microsoft Update Opt-In page, specify if you want to sign up for the Microsoft Update service, and then click Upgrade.

  9. On the Summary of Settings page, review the summary of installation settings. To install DPM using the specified settings, click Install. To change the settings, click Back.

    After the installation is complete, the Installation page displays the installation status.

  10. Click Close, and then restart the computer to incorporate all of the DPM Setup changes.

  11. Restart the DPM Server.

    Note the following after you restart the DPM 2010 server:

    • Make sure that you save the backup of the DPMDB database from the MS$DPM2007$ instance of SQL Server in a safe location.

    • You can uninstall the MS$DPM2007$ instance of SQL Server from the DPM server because it is not required for DPM 2010.

Upgrading an x86-bit DPM Server using a Remote Instance of SQL Server

Before you perform the upgrade, we strongly recommend that you back up the DPMDB database.

To back up the DPMDB database

  1. To back up the DPMDB database, from the command prompt, type DPMBackup.exe -db, located at <drive letter>:\Program Files\Microsoft Data Protection Manager\DPM\bin.

  2. In the console tree of the backup program, browse to \Program Files\Microsoft Data Protection Manager\DPM\Volumes\ShadowCopy\Database Backups. The file name of the DPM database backup is DPMDB.bak.

  3. Copy the database backup file to a network share.

To upgrade an x86-bit DPM server using a remote instance of SQL Server

  1. Remove the x86 DPM server from the network.

  2. Install Windows Server 2008 or Windows Server 2008 R2 on an x64-bit computer.

  3. Rename the computer with the name of the DPM server that you removed from the network.

  4. Install DPM 2007 on the x64-bit computer (the installation location will remain the same as the x86-bit computer).

  5. To restore the DPMDB database, from the command prompt, type dpmsync –restoredb.

  6. To perform a synchronization, type dpmsync –sync.

  7. Start the upgrade.