July 19, 2002 at 11:01 am
I'm a new DBA and need more understanding of applying Microsoft Hotfixes.
When viewing the download page( http://support.microsoft.com/default.aspx?scid=kb;en-us;Q316333 )for this fix, there are 3 releases (July 10, 2002 - April 17, 2002 - February 20, 2002) each with a separate download for the indicated fixes(Q322853, Q319507 and Q317979).
Do all 3 of these files need to be downloaded and applied?
If so, in what order? I thought the July file would take care of the entire issue but the other 2 files appearing on that page confuses me.
Lastly, when running the Network Security Hotfix Checker on SQL2K SP2 servers, it seems to list the Q316333 issue as resolved, but then again, I may not be reading it's
output correctly. It's output is pasted at the bottom of this post.
My thanks in advance for anyone willing to spend their valuable time in responding to this.
PK
* SQL SERVER 2000 SP2
Note MS02-020 Q316333
Please refer to Q306460 for a detailed explanation.
Note MS02-030 Q321858
Please refer to Q306460 for a detailed explanation.
Note MS02-030 Q321858
Please refer to Q306460 for a detailed explanation.
Note MS02-030 Q321460
Please refer to Q306460 for a detailed explanation.
Note MS02-030 Q320833
Please refer to Q306460 for a detailed explanation.
Note MS02-034 Q322853
Please refer to Q306460 for a detailed explanation.
Note MS02-035 Q263968
Please refer to Q306460 for a detailed explanation.
July 19, 2002 at 11:44 am
If you apply Q322853 you should be all set. Read the following from the page (I usually gloss over this but if you read it carefully it makes sense);
Microsoft distributes SQL Server 2000 security fixes as one downloadable file. Because the security fixes are cumulative, each new release contains all of the security fixes that were included with the previous SQL Server 2000 security fix release. You do not have to install a previous patch before you install the latest one. This Microsoft Knowledge Base article contains a list of all the security fixes that are available for SQL Server 2000 Service Pack 2 (SP2).
As for the odd reporting with "Hotfix Checker", I don't know but my guess is it will clear when you run the update.
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 19, 2002 at 12:32 pm
Thanks for clarifying that for me, David.
I'm still second guessing alot of decisions at this stage of my game. (Of course, I'll apply the patch to a test box first).
This is greatly appreciated.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply