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 |
|
bhimrajg
Starting Member
5 Posts |
 Posted - 2008-12-10 : 06:58:32
|
Hi all,Our current SQL server 2005 version is :Microsoft SQL Server 2005 - 9.00.1406.00 (Intel X86) Mar 3 2007 18:40:02 Copyright (c) 1988-2005 Microsoft Corporation Workgroup Edition on Windows NT 5.2 (Build 3790: Service Pack 1) Recently Our AlertSite security monitoring service made the report against our server and marked it HIGH severity. So we need install security patches released by microsoft.Here is the link :[url]http://www.microsoft.com/technet/security/bulletin/ms08-040.mspx[/url]For these security patches, we need to install SP2 for SQL server 2005. We'll be downloading and testing SP2 on test machine before trying it on PROD server. I am not a DBA and dont know much about what issues we could face in this migration. Would there be any problems ?Please share your thoughts.Also, I read that SP2 can not be uninstalled [[url]http://www.mssqltips.com/tip.asp?tip=1186[/url]] and it needs complete uninstallation of SQL server 2005. Is that correct ? |
|
|
brianjensen
Starting Member
22 Posts |
Posted - 2008-12-10 : 07:18:21
|
| Yes, you cannot remove SP's when they have been installed nor minor og cumulative updates.I don't know anything about your system, but installing SP2 will not do dramatic changes to how other programs interfaces with the sql server and ssis packages should also function after installing it.However, installing it onto a test server may be the way to go since I have once (and only once) seen a system having problems with SP2. This was some old software that needed to be uninstalled and then installed again in order to work under SP2. I can't explain why :) |
 |
|
|
|
|
|
Installing SP2 for SQL server 2005