Add as a preferred source on Google


SQL Server 2005 SP3 Expected in Summer '08

  • By Kurt Mackie
  • 04/18/08
##AUTHORSPLIT##<--->

Microsoft this week announced through two blogs that it plans to release the next service pack to SQL Server 2005, Service Pack 3 (SP3). The release is timed for the third quarter of this year, or after Microsoft releases SQL Server 2008 to manufacturing.

In addition, Microsoft issued notes Monday describing the availability of Cumulative Update 7 (CU 7) for SQL Server 2005 Service Pack 2.

CU 7 is intended for users "severely affected" by certain problems. Those not affected should wait until the next service pack is released, according to Microsoft's notes.

Microsoft's PSS SQL Server engineers strongly caution that applying CU 7 can affect "Analysis Services backup and sync operations." The problem is associated with a time-out issue, as the PSS SQL blog explains.

"After the fix a backup is treated as a blocker for a commit operation. Due to the way that lock compatibility operates in Analysis Services, once the commit operation is blocked, all incoming requests against objects in the database are also blocked."

The blog describes some workarounds, but it generally recommends that administrators schedule "database backups at a time that will not overlap with processing of objects in the database."

The Cumulative Updates are part of Microsoft's "incremental servicing model" -- a three-pronged approach to releasing important code corrections that Microsoft calls "hotfixes." Microsoft's Cumulative Updates contain all previously released critical on-demand hotfixes and are released every two months. They must be requested by customers, but any customer, regardless of their support level can request them.

A second way to get hotfixes is through Microsoft's "On-Demand" and "Critical-On-Demand" releases, which are solutions to specific customer-referenced problems that have no workaround fix.

The third way that Microsoft releases hotfixes is in a "general distribution release." Microsoft issues these general distribution releases when it needs to fix problems that affect customers more broadly, such as when security issues are involved.

Microsoft already has uploaded a page describing its next Cumulative Update for SQL Server 2005 Service Pack 2. Cumulative Update 8, as it's called, is scheduled for release sometime in June.

Get daily news from THE Journal's RSS News Feed

About the author: Kurt Mackie is Web editor of RCPmag.com and ADTmag.com. He can be reached at [email protected].

Proposals for articles and tips for news stories, as well as questions and comments about this publication, should be submitted to David Nagel, executive editor, at [email protected].

About the Author

Kurt Mackie is online news editor, Enterprise Group, at 1105 Media Inc.

Featured

  • hand holding globe and environmental icons in front of a green background

    CoSN, SETDA, UDT Release Guidelines for Environmentally Responsible Technology Purchasing

    CoSN and SETDA, in partnership with IT and telecommunications solution provider UDT, recently released a set of Sustainability Procurement Guidelines designed to help K-12 school and district leaders, procurement officers, and technology directors make purchasing decisions that are both environmentally responsible and operationally effective.

  • illustration of stacked coins, bar graphs, downward arrows, and two school buildings

    Survey: Top Education and Budget Challenges for Schools

    A recent survey of more than 2,500 educators, school leaders, and district administrators across the country identified the top challenges schools are facing this year. The 2025 National Educator Survey, conducted by PowerSchool, found that teacher shortages and mounting financial uncertainty are persistent pain points across K-12 education.

  • interconnected gears and cogs

    Integration Brings Anthropic Claude AI Models to Copilot

    Microsoft has integrated Anthropic's Claude artificial intelligence models to its Microsoft 365 Copilot platform, giving enterprise users another option beyond OpenAI's models for powering workplace AI experiences.

  • cybersecurity book with a shield and padlock

    Proposed NIST Cybersecurity Guidelines Aim to Safeguard AI Systems

    The National Institute of Standards and Technology has announced plans to issue a new set of cybersecurity guidelines aimed at safeguarding artificial intelligence systems, citing rising concerns over risks tied to generative models, predictive analytics, and autonomous agents.