April 12, 2007 at 8:29 am
I have a server running 2 named instances of sql 2000.
They are both using sp3a.
I would like to upgrade one instance to sp4 and leave the other at sp3a.
Is there any problem with doing that?
Thanks
April 13, 2007 at 12:58 am
It should not be a problem.
April 13, 2007 at 2:58 am
It should work, but I have experienced the following problem...
When SQL Server installs the SQL services, some of the path names are in 8.3 format (e.g. mssqls~1, mssqls~2, etc). I had one box where the install process got the 8.3 format name wrong, so that the ABC instance was actually running from the DEF instance program folder.
It is worth finding out the 8.3 format of the SQL Server program folders for all your instances, and checking in the Services section of the registry that everything is OK. For our bad instance, I tweaked the relevant registry key and bounced the SQL instance to get it using the correct folder.
I was disappointed to see 8.3 file names scattered in the SQL 2005 install logs, so this obsolete name format will haunt us for a few years to come...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply