none
DPM in place upgrade from SQL 2008 to SQL 2014 RRS feed

  • Question

  • Has anyone experience or the steps to do an in place upgrade of SQL standard 2008 to SQL 2014. DPM 2012R2 is running on Windows Server 2012 R2 Datacenter.
    Wednesday, September 4, 2019 3:31 PM

All replies

  • Hello,

    Yes this is doable, is your DPM database located locally on the DPM server or remotely?

    SQL Server 2014 supports upgrade from the following versions of SQL Server:

    • SQL Server 2005 SP4 or later
    • SQL Server 2008 SP3 or later
    • SQL Server 2008 R2 SP2 or later
    • SQL Server 2012 SP1 or later

    More information over here:
    Upgrades from Earlier Versions to SQL Server 2014


    There are three (3) possible scenarios for upgrading the DPM database:

    1. Upgrade local to local
    Use this option if you want to continue to have DPMDB on the same computer as Data Protection Manager.

    2. Upgrade local to remote
    Use this option when you want to move from using a local instance of DPMDB to a remote instance. Using this feature, one instance of SQL Server can host the databases of multiple Data Protection Manager servers.

    3. Upgrade remote to remote
    Use this option when you want to continue to use a remote instance of SQL Server to host the DPMDB. Using this feature, one instance of SQL Server can host the databases of multiple Data Protection Manager servers.

    You can read more about these options over here:
    Upgrade the DPM Database

    If your DPM database is installed locally on the DPM server, then all you have to do is:

    1. Shut down all the DPM services.

    2. Backup your DPM database.

    3. Perform an upgrade installation of SQL Server.

    4. Start the DPM services.

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    • Proposed as answer by Leon Laude Friday, September 6, 2019 9:09 AM
    Wednesday, September 4, 2019 5:21 PM
  • Thanks for the quick reply Leon.

    The upgrade Upgrade local to local went smooth thanks to your procedure above.

    The only issue I had was  the Tape Management reports returned the following error:

    "Failed to load expression host assembly. Details: Could not load file or assembly 'ReportSRV4, Version=1.0.523.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. (rsErrorLoadingExprHostAssembly)"

    This was fixed by coping ReportSRV4.dll from

    C:\Program Files\Microsoft System Center 2012\DPM\SQL\MSRS10_50.MSDPM2012\Reporting Services\ReportServer\bin

    Into

    C:\Program Files\Microsoft System Center 2012\DPM\SQL\MSRS12.MSDPM2012\Reporting Services\ReportServer\bin

    I found this fix here :

    https://social.technet.microsoft.com/Forums/en-US/63dc88ff-437b-4d9b-bdca-95a8ee621fd5/reporting-fails-to-load?forum=dataprotectionmanager

    Thanks again for your help.


    Pat McMorrow



    • Proposed as answer by Leon Laude Friday, September 6, 2019 9:10 AM
    • Edited by Pat McMorrow Friday, September 6, 2019 9:48 AM
    Friday, September 6, 2019 9:08 AM
  • Great to hear that Pat, and thanks for sharing your experience and your solution for the reports issue!


    Blog: https://thesystemcenterblog.com LinkedIn:

    Friday, September 6, 2019 9:09 AM
  • Hello Pat,

    Would you mind marking the replies that were helpful as answer? This helps the community to recognize helpful contributions, thank you!


    Blog: https://thesystemcenterblog.com LinkedIn:

    Sunday, September 8, 2019 4:15 PM