Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lasmith
Starting Member
5 Posts |
 Posted - 2012-04-13 : 08:45:54
|
| Does anyone know if there is an issue patching a 2nd named instance of SQL 2008 when the base install is RTM? I can't get SP1 to apply. I goes through the steps but when I check @@version, it has not been applied. The default instance is at SP1 and has been in production for over a year.lasmith, DBA |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2012-04-13 : 08:54:48
|
Are the files in use?Does the installer proceed without errors?Do you choose the right instance to upgrade?
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
lasmith
Starting Member
5 Posts |
Posted - 2012-04-13 : 09:13:30
|
| The files are not in use.There are no errors returned by the installer to the screen.I select the instance by name during the install.The patch appears to run successfully...it just doesn't register on the instance.lasmith, DBA |
|
|
|
lasmith
Starting Member
5 Posts |
Posted - 2012-04-13 : 10:01:05
|
| I have uninstalled and am reinstalling now to make sure I haven't missed any of the steps.lasmith, DBA |
|
|
|
lasmith
Starting Member
5 Posts |
Posted - 2012-04-13 : 10:06:31
|
| On the second attempt, I must recant my third statement. The SP1 install does not allow me to select the named instance. Only the "Shared Features" are available, and they do not need patched. What am I doing wrong?Here is the file I am using: SQLServer2008SP1-KB968369-x86-ENU.exelasmith, DBA |
|
|
|
lasmith
Starting Member
5 Posts |
Posted - 2012-04-13 : 11:27:16
|
| I downloaded a new copy of SP1 and upgrade was successful. Sorry to have bothered you all.lasmith, DBA |
|
|
|
|
|
|
Problem Patching 2nd Instance