+ Post New Thread
Results 1 to 6 of 6
Enterprise Software Thread, DPM 2012 - SP1 Upgrade SQL Problem in Technical; Hi, I am trying to upgrade DPM 2012 to 2012 SP1. Its getting to the point where its upgrading SQL ...
  1. #1

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    16,058
    Thank Post
    888
    Thanked 1,731 Times in 1,494 Posts
    Blog Entries
    12
    Rep Power
    454

    DPM 2012 - SP1 Upgrade SQL Problem

    Hi,

    I am trying to upgrade DPM 2012 to 2012 SP1. Its getting to the point where its upgrading SQL Server 2008 R2 to SP2. Its failing and telling me to upgrade SQL manually. I have done this and rebooted. Its still trying to upgrade SQL and telling me to upgrade to SQL SP2 manually even though i have done this. I can't get past this point, its telling me to do something i have already done. When i run the SP2 installer again its confirming that SQL is on SP2.

    Any thoughts please?

    Thanks

  2. #2

    Join Date
    Feb 2007
    Location
    Wolverhampton
    Posts
    330
    Thank Post
    18
    Thanked 35 Times in 33 Posts
    Rep Power
    21
    Quote Originally Posted by FN-GM View Post
    Hi,

    I am trying to upgrade DPM 2012 to 2012 SP1. Its getting to the point where its upgrading SQL Server 2008 R2 to SP2. Its failing and telling me to upgrade SQL manually. I have done this and rebooted. Its still trying to upgrade SQL and telling me to upgrade to SQL SP2 manually even though i have done this. I can't get past this point, its telling me to do something i have already done. When i run the SP2 installer again its confirming that SQL is on SP2.

    Any thoughts please?

    Thanks
    I had something similar to this before where it asked for a particular SQL version. I manullay upgraded and found that it stilled complained.

    If memory serves me correctly, I think it turned out to be a reg key that had not been updated during the upgrade process. I manually changed the reg key value and the install worked fine.

    I can't remember the key but it is what is checked for installation to commence. Can we interegate the SQL version from WMI?

  3. #3

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    16,058
    Thank Post
    888
    Thanked 1,731 Times in 1,494 Posts
    Blog Entries
    12
    Rep Power
    454
    Will have a check in the morning.

    I might upgrade to SQL 2012 then try upgrading the SP. Then it will totally skip the SQL 2008 R2 step (in theory)

  4. #4

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    16,058
    Thank Post
    888
    Thanked 1,731 Times in 1,494 Posts
    Blog Entries
    12
    Rep Power
    454
    The install of DPM says we are on SP2

  5. #5

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    16,058
    Thank Post
    888
    Thanked 1,731 Times in 1,494 Posts
    Blog Entries
    12
    Rep Power
    454
    This is what the log says.

    Code:
    Overall summary:
       Final result:                  Passed
       Exit code (Decimal):           0
       Exit message:                  Passed
       Start time:                    2013-01-07 13:42:05
       End time:                      2013-01-07 13:42:41
       Requested action:              Install
     
    Machine Properties:
       Machine name:                  FP-BACKUP
       Machine processor count:       4
       OS version:                    Windows Server 2008 R2
       OS service pack:               Service Pack 1
       OS region:                     United Kingdom
       OS language:                   English (United States)
       OS architecture:               x64
       Process architecture:          64 Bit
       OS clustered:                  No
     
    Product features discovered:
       Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered
       Sql Server 2008 R2   MSDPM2012            MSSQL10_50.MSDPM2012           Database Engine Services                 1033                 Standard Edition     10.52.4270.0    No       
       Sql Server 2008 R2   MSDPM2012            MSRS10_50.MSDPM2012            Reporting Services                       1033                 Standard Edition     10.52.4270.0    No       
       Sql Server 2008 R2                                                       Management Tools - Basic                 1033                 Standard Edition     10.52.4270.0    No        
      Sql Server 2008 R2                                                       Management Tools - Complete              1033                 Standard Edition     10.52.4270.0    No        
    
    Package properties:
       Description:                   SQL Server Database Services 2008 R2
       ProductName:                   SQL Server 2008 R2
       Type:                          RTM
       Version:                       10
       Installation location:         C:\Users\UserDesktop\DPM 2012 SP1\Sys_Ctr_DPM_2012_wSP1_Multi-Language_-2_X18-80381\SCDPM\SQLSVR2008R2SP2\x64\setup\
       Installation edition:          STANDARD
     
      Slipstream:                    True
       SP Level                       2

  6. #6

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    16,058
    Thank Post
    888
    Thanked 1,731 Times in 1,494 Posts
    Blog Entries
    12
    Rep Power
    454
    In the end this is how i fixed it

    1. Backup the Database in the command prompt, DPMBackup.exe -db, located at Microsoft Data Protection Manager\DPM\bin .

    2. The backup will live in Microsoft Data Protection Manager\DPM\Volumes\ShadowCopy\Database - copy this folder to a folder in the root of the C drive.

    3. Uninstall DPM 2012 select the option to retain the data.

    4. Uninstall all SQL stuff on the DPM box.

    5. Reboot

    6. Install DPM 2012, without SP1. During the upgrade select the option to use windows updates

    7. Don't open DPM at all. Run this command to restore the database by typing - DpmSync –restoredb –dbloc <DPMDB location>

    8. Run this command DpmSync -sync

    9. Run windows updates and install any DPM updates. Do not install any SQL updates.

    10. Then run the SCCM 2012 SP1 upgrade.

    11. Once thats done (it should work now) perform a consistency check.

SHARE:
+ Post New Thread

Similar Threads

  1. is 5:30 on a friday the right time to start a DPM 2012 upgrade
    By k-strider in forum Enterprise Software
    Replies: 3
    Last Post: 31st August 2012, 06:29 PM
  2. Replies: 2
    Last Post: 26th February 2009, 01:21 PM
  3. SIMS upgrade backup problem
    By ee01akk in forum MIS Systems
    Replies: 3
    Last Post: 29th August 2008, 11:37 AM
  4. WiseSoft ScriptBuilder + SQL problem
    By j17sparky in forum Windows
    Replies: 2
    Last Post: 9th February 2008, 06:33 PM
  5. Library Management System - SQL Problem
    By AnnDroyd in forum Network and Classroom Management
    Replies: 0
    Last Post: 2nd October 2007, 08:45 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •