Export (0) Print
Expand All
1 out of 3 rated this helpful - Rate this topic

Upgrading the DPM Database

Updated: November 1, 2013

Applies To: System Center 2012 - Data Protection Manager, System Center 2012 R2 Data Protection Manager, System Center 2012 SP1 - Data Protection Manager

An important part of upgrading to System Center 2012 – Data Protection Manager (DPM) is upgrading the DPM database (DPMDB). With the multi-database feature, DPM allows you to consolidate the databases of all your DPM servers to one SQL Server instance. When upgrading, you have to choose one of three scenarios.

ImportantImportant
  • Upgrade your DPM servers sequentially. Parallel upgrades may lead to errors.

  • If you are using an existing instance of SQL Server, you must run DPM Remote SQL Prep tool from the Setup splash screen on the instance of SQL Server you are going to use.

  • You cannot share an instance of SQL Server installed by DPM. We recommend you use it only for DPM databases.

  • TCP/IP protocol must be enabled on SQL Server and TCP/IP client protocol on DPM server.

  • When setting up tape library sharing, provide the complete name as <servername>\<instancename>\<databasename>.

  • The naming conventions for the DPM database have changed with this new feature, and you can find the name of the database from the Information button on the Administrator console.

Local SQL Server instance to Local SQL Server instance

  1. Backup DPMDB.

  2. Add Microsoft$DPM$ACCT to the ACL for the DPMDB folder, if it doesn’t exist. Add full control to the user.

  3. Launch System Center 2012 – Data Protection Manager (DPM) installation. This will start setup in upgrade mode.

Local SQL Server instance to remote SQL Server instance

  1. Ensure that the domain user account you will use to install DPM is a member of all the following:

    • The local Administrators group on the DPM server.

    • The SQL Server Sysadmin fixed server role on the computer on which you have installed the remote instance of SQL Server 2008 R2.

    noteNote
    After setup is complete, you can remove the user account from the local Administrators group on the computer running the remote instance of SQL Server.

  2. Backup DPMDB.

  3. Add Microsoft$DPM$ACCT to the ACL for the DPMDB folder, if it doesn’t exist. Add full control to the user.

  4. Restore the DPMDB backup to a remote instance of SQL Server 2008 R2 which you plan to use to host databases of multiple DPM servers.

    noteNote
    The name of the restored database should be DPMDB.

    This instance of SQL Server should be used only for hosting DPM databases only.

  5. Ensure that TCP/IP protocol is enabled for this instance of SQL Server.

  6. Install SQL Prep Tool on the remote computer running SQL Server. You can find this on the Setup page.

  7. Launch DPM installation. This will start setup in upgrade mode.

Remote SQL Server instance to Remote SQL Server instance

  1. Ensure that the domain user account you will use to install DPM is a member of all the following:

    • The local Administrators group on the DPM server.

    • The local Administrators group on the computer on which you have installed the remote instance of SQL Server 2008 R2.

    • The SQL Server Sysadmin fixed server role on the computer on which you have installed the remote instance of SQL Server 2008 R2.

    noteNote
    After setup is complete, you can remove the user account from the local Administrators group on the computer running the remote instance of SQL Server.

  2. Backup DPMDB.

  3. Restore the DPMDB backup to a remote instance of SQL Server 2008 R2 that you plan to use to host databases of multiple DPM servers.

    noteNote
    • The name of the restored database should be the same as the DPM database you backed up.

    • This instance of SQL Server should be used only for hosting DPM databases only.

  4. Ensure that TCP/IP protocol is enabled for this instance of SQL Server.

  5. Install SQL Prep Tool on the remote instance of SQL Server.

  6. Launch DPM installation. This will start setup in upgrade mode.

See Also

-----
For additional resources, see Information and Support for System Center 2012.

Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.
-----
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.