October 22, 2007 at 10:42 am
I need to apply 2187 to SQL2000 SP4 2162. Does this require SQL server to restart?
Does any one have any experience/problem while doing this on a geographic cluster environment? Just want to be aware of any possible problems.
Thank you,
Vivien
October 23, 2007 at 5:08 am
Vivien,
I have applied 2187 a number of times to standalone servers (W2003) and it has requested a server reboot each time. It has also been unable to restart the server from the hotfix installer so I had to do it manually.
If this happens on your cluster could complicate things for you, but as long as you have the remote access to restart the servers you should be fine. Ensure you apply hotfix from a share on the primary which is visible to the secondary.
Actual install of 2187 always worked fine and has never given any operational problems post fix.
HTH
george
---------------------------------------------------------------------
October 23, 2007 at 9:31 am
Thank you George. Good to know those unexpected events.
I tried to search build 2162 so I can set up a test. But I could not find it.
October 24, 2007 at 2:47 am
My recollection is that the HF 2187 apply process stops and starts the SQL instance.
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
October 24, 2007 at 3:59 am
yes, it stops and starts the SQL services as part of the install, and then requests a server reboot at the end.
---------------------------------------------------------------------
October 24, 2007 at 4:17 am
no i'm not sure. Its the privledge of config file installation....
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply