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 |
|
cDc
Starting Member
30 Posts |
 Posted - 2003-01-02 : 12:30:12
|
| Hi - I would like to patch a (fairly critical) DB server and I was just wondering if there was any particular order to patching as I know how windows can start to play up if things arent done properly. I think that the machine has nto been patched at all since being installed as there are 30 outstanding windows 2000 security/service patches to be done via windowsupdate (including IE6 and service pack 3), and I have not patched SQL server before so I assume I need to upgrade SQL2K to service pack 2? - are there any other things I have missed? Cheers! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-02 : 12:47:14
|
| You definitely need to start with service pack 2 for SQL Server before you try to install the sql security patches. Since the patches are cumulative (at least for sql they are), you only need to apply the latest one. They are a real pain in the neck because it involves stopping/starting services, manually replacing files, and running scripts. There is no setup.exe. Just make sure that you follow the instructions in the readme.txt file that comes with the patch. |
 |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-01-03 : 03:52:47
|
| It used to be (still is , afaik), fairly standard practice to re-apply NT service packs after any "major" change - like a SQL service pack. I assume this is true for Windows 2000. If so, I would say, do yous SQL SP2, SQL secutiry patches, then your OS SP's and patches, although our system guys here see to prefer "overkill" : OS SP's and patches, the SQL SP and patches, then OS SP's and patches.Obviously, you need to check any pre-requisites, but I don't think that the SQL sp's require windows sp levels.Has anyone done all of this, maybe they can comment on what they did ?Good Luck*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-03 : 12:24:00
|
| We do not reapply the Windows service packs after the SQL security patches because the dlls and other files that are affected by the SQL security patches do not relate to the files in the Windows service packs. |
|
|
|
|
|
|
|
|
SQL2k/Win2k Patches..