News

Microsoft Delivers SQL Server 2005 SP3

Microsoft ratcheted up its product support for SQL Server 2005 by releasing Service Pack 3 (SP3) on Monday, along with SP3 Cumulative Update 1.

Microsoft ratcheted up its product support for SQL Server 2005 by releasing Service Pack 3 (SP3) on Monday, along with SP3 Cumulative Update 1. On the same day, the company also released Cumulative Update 11 for SQL Server 2005 Service Pack 2 (SP2).

If that weren't enough, the company offered incentives for Microsoft's partners and Microsoft Dynamics customers to jump to SQL Server 2008, which was released as a product last summer.

Microsoft is updating its price list on January 1, 2009 and will replace the runtime for SQL Server 2005 with that of Microsoft SQL Server 2008, according to a Microsoft Dynamics blog.

"Customers who have licensed Microsoft SQL 2008-Runtime and are current on the Business Ready Enhancement Plan as of January 1, 2009 will be entitled to an upgrade to Microsoft SQL Server 2008," the blog explained.

Features in SQL Server SP3 include "supportability enhancements," plus improvements in the database engine, notifications services, replication and reporting services, according to an MSDN library Web page. SP3 contains all previously released cumulative updates for SQL Server 2005.

KnowledgeBase articles for SP3 are available through the release notes here.

For SQL users not opting for SP3, Microsoft released Cumulative Update 11 for SQL Server 2005 SP2, which contains all of the hot fixes for SP2, without the new features in SP3.

However for those who are moving from SQL Server SP2 to SP3, Microsoft offers a caveat. Be sure to apply SP3 Cumulative Update 1.

"If you are upgrading from SQL Server 2005 SP2 Cumulative Update 10 or from SQL Server 2005 SP2 Cumulative Update 11, you must apply a post-SP3 cumulative update after you upgrade to SP3 to obtain all the fixes," according to Nick MacKechnie's blog.

For those wanting more than just blog advice, Microsoft's "Books Online" release for Microsoft SQL Server 2005 is available here. It provides primary documentation, including setup and upgrade instructions for SP3.

Microsoft also released a new Feature Pack for SQL Server 2008 on Monday that provides optional add-ons for the database solution. The December Feature Pack can be accessed here.

For more information and links to documentation, visit the Swiss IT Professional and TechNet Blog.

About the Author

Herb Torrens is an award-winning freelance writer based in Southern California. He managed the MCSP program for a leading computer telephony integrator for more than five years and has worked with numerous solution providers including HP/Compaq, Nortel, and Microsoft in all forms of media.

Featured

  • Spaceflight Training in the Middle of a Pandemic

    Surprisingly, the worldwide COVID-19 lockdown has hardly slowed down the space training process for Brien. In fact, it has accelerated it.

  • Surface and ARM: Why Microsoft Shouldn't Follow Apple's Lead and Dump Intel

    Microsoft's current Surface flagship, the Surface Pro X, already runs on ARM. But as the ill-fated Surface RT showed, going all-in on ARM never did Microsoft many favors.

  • IT Security Isn't Supposed To Be Easy

    Joey explains why it's worth it to endure a little inconvenience for the long-term benefits of a password manager and multifactor authentication.

  • Microsoft Makes It Easier To Self-Provision PCs via Windows Autopilot When VPNs Are Used

    Microsoft announced this week that the Windows Autopilot service used with Microsoft Intune now supports enrolling devices, even in cases where virtual private networks (VPNs) might get in the way.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.