SQL 2000 SP3 concerns

  • I am a new Admin for a series of SQL 2000 clusters for the Navy.  I have been tasked with researching any potential problems with applying SQL 2000 SP3 to six different SQL clusters.  They are all Win2K Adv Servers machines, patched to Win2K SP4, with nothing else running on them.  The hardware for the most part is Dell 4350's and 1650 Blades.  Any thoughts or experiences which would be helpful?

    Thanks.

    David

  • I have a number of Dell 4350's running stand alone SQL2000 W2KAS SP4 which were updated to SQL SP3 recently with no problems.

    Our application processes the routing and delivery of 10's of thousands of phone calls daily with 99.99% uptime  (per server).

    Hope this helps.

  • My experience has been mixed.  SP3 upgrade went great on most servers but was a little tricky on several of our active/active clusters.  If you have multiple instances running, you will need to shut down all of the instances you are not upgrading as you upgrade each one - even instances running on the machine in the cluster where the instance you are upgrading is NOT running currently.  In other words, this means all instances on both nodes in an active/active cluster except the one begin upgraded.  Also, close the SQL monitor in the tray on all nodes in the clusters.  Not doing these steps can cause the cluster install to fail becasue of locked 'shared' files.  This is true even if the file it is installing has already been upgraded (ie via the first instance upgrade).  We also use MOM (Microsoft Monitoring) and this service needs to be shut down as it can lock some of the files that need to be upgraded.  I had some full text issues after the install.  I noticed a new white paper last month that describes how to fix full text issues.  If you use full text, I recommend finding this before you upgrade in case you have to use it.  The gist of the recommended fix is to reregister the DLLs from the search folder.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply