Friday, November 16, 2012 5:02 PM
We are currently running SQL Server 2005, and are still on SP2 and I just learned that SP4 exists for SQL 2005. I just wanted to ask if somebody else did an upgrade from SP2 to SP4 and if there were any problems in the update process or if it all went smoothly. I need to ease myself SQL 2005 Service Pack 4 are there any reasons NOT to upgrade from 2 to 4 directly or are there any user examples out there where someone got a real benefit from upgrading to SP4, because we have to make a case to Management and the network to prove it is worth it.
Friday, November 16, 2012 6:47 PMModerator
SP4 includes updates of SP3 also. It has many improvements for SSIS, replication, service broker, database mirroring, replication, transact-sql (LIKE, CASE), DBCC command, MDX, etc.
I strongly recommend you to install that service pack.
Please read the following article to know all the benefits of installing SP4:
Hope this helps.
Saturday, November 17, 2012 9:43 AM
In addition to the improvements and bug fixes available with SP4, you could also let your management know that anything below SQL Server 2005 SP4 is out of support meaning, if you encounter any issue Microsoft will help you only on best afford basis.
When support for a service pack ends, Microsoft will no longer provide new security updates, DST updates, hotfixes or other updates for that service pack. Limited support will continue to be available.For customers on supported products with service pack versions that have left full support, Microsoft offers limited support as follows:
- Limited break/fix support incidents will be provided through Microsoft Customer Service and Support and Microsoft’s managed support offerings (such as Premier Support).
- If the support incident requires escalation to development for further guidance, requires a hotfix, or requires a security update, customers will be asked to upgrade to a fully supported service pack.
- Limited support does not include an option to engage Microsoft’s product development resources; technical workarounds may be limited or not possible
- Proposed As Answer by V. Keerthi Deep Sunday, November 18, 2012 2:45 AM
Saturday, November 17, 2012 4:04 PM
I agree with Keerthi and Alberto...!
Applying latest SP/hot fix avoids many problem/High Incident/ Business risk etc.... so it is good plan to apply the latest SP/Hotfix as per Microsoft releases..
But the only way is -> you need to talk to your Business on this to get the approval to go ahead, Also I have seen some of the cases still the business
they don't want to go with the latest, because there vendor/applications Tightly stitched to current.. so in order to go for new one they have to do some testing with latest one for their apps so they can do on the test servers to see how it goes for an day/week.. then they can switch to production later...!
But they have to ensure that the good backup in place along with SQL server DB engine information...in handy!
Thanks, Rama Udaya.K "“You only live once, but if you do it right, once is enough. ― Mae West". ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.