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 ...
6th January 2013, 05:41 PM #1
DPM 2012 - SP1 Upgrade SQL Problem
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?
6th January 2013, 07:19 PM #2
I had something similar to this before where it asked for a particular SQL version. I manullay upgraded and found that it stilled complained.
Originally Posted by FN-GM
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?
7th January 2013, 01:57 AM #3
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)
7th January 2013, 12:59 PM #4
The install of DPM says we are on SP2
7th January 2013, 02:53 PM #5
This is what the log says.
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 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
Description: SQL Server Database Services 2008 R2
ProductName: SQL Server 2008 R2
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
SP Level 2
9th January 2013, 12:19 AM #6
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.
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.
By k-strider in forum Enterprise Software
Last Post: 31st August 2012, 07:29 PM
By tonijh in forum MIS Systems
Last Post: 26th February 2009, 02:21 PM
By ee01akk in forum MIS Systems
Last Post: 29th August 2008, 12:37 PM
By j17sparky in forum Windows
Last Post: 9th February 2008, 07:33 PM
By AnnDroyd in forum Network and Classroom Management
Last Post: 2nd October 2007, 09:45 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)