David Wimbush avatar image
David Wimbush asked

Service packs for previous version of SQL

I did an in-place upgrade from SQL 2012 to SQL 2014. Windows Update is now recommending I install a SQL 2012 service pack. I don't remember seeing such a thing before so maybe something has changed. Surely the upgrade overwrote the SQL 2012 components with SQL 2014 components. Please advise: should I install this service pack and how do you know?
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
If you run the setup.exe for 2014, click Tools on the left hand side and then choose the 'Installed SQL Server features discovery report', you get a server wide glance of what is installed.
2 Likes 2 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Alternatively, it might be worth manually launching SQL2012SP2, and seeing what components it can identify as still being installed... Also, take a look in the file system to see what's hanging around. It won't necessarily give you an accurate view, but you should get some idea from looking in C:\Program Files\Microsoft SQL Server\... and the equivalent x86 directory structure. NB: Don't go messing with this stuff manually, though - just use it as a way of getting ideas about what might still be installed.
1 Like 1 ·
KenJ avatar image KenJ commented ·
what is your current 2014 build and which 2012 service pack is it recommending?
0 Likes 0 ·
David Wimbush avatar image David Wimbush commented ·
Hi Ken. Its SQL 2014 build 12.0.4100.1. Windows Update has SQL 2012 Service Packs 1 & 2 as important updates.
0 Likes 0 ·
Arcanas avatar image Arcanas commented ·
Would it be possible to run the 2014 installer and see if there are any components on the system that still require an update?
0 Likes 0 ·
Show more comments

0 Answers