2012年8月2日 星期四

SQL Server 2008R2 SP2 發佈更新與說明

        等待已久的SQL Server 2008 R2 SP2,終於在7/26日的時候發佈了,這次主要修正了8個主要的問題外,額外也進行了24項的修正,詳細的說明請參考官網上 KB2630458,詳細介紹如下,再請參考。

安裝時系統會進行檢查,確認您已有裝的SQL Server的功能與版本。

 安裝完成後,您會看到版本就會變成 [10.50.4000]。


針對客戶不斷的需求提出,本修正也作了下列的更新與異動:

  • Reporting Services Charts Maybe Zoomed & Cropped Customers using Reporting Services on Windows 7 may sometime find charts are zoomed in and cropped. To work around the issue some customers set ImageConsolidation to false.
  • Batch Containing Alter Table not Cached In certain situations with batch files containing the alter table command, the entire batch file is not cached.
  • Collapsing Cells or Rows, If Hidden Render Incorrectly Some customers who have hidden rows in their Reporting Services reports may have noticed rendering issues when cells or rows are collapsed. When writing a hidden row, the Style attribute is opened to write a height attribute. If the attribute is empty and the width should not be zero.


主要修正問題:
VSTS bug numberKB article numberDescription
820875922578FIX: Lots of messages that have message ID 19030 and message ID 19031 are logged in SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2 Errorlog file when you use SQL Server Profile in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2
7285272216456SQL Server 2008 Service Pack 2 and SQL Server 2008 R2 Service Pack 2 enhancements to the "Operation has been cancelled" error message text in Analysis Services
8208582550375FIX: Deadlock might occur in sys.dm_database_encryption_keys DMV in SQL Server 2008 R2 when you run log shipping from many databases to one secondary server
8208782565683FIX: You may receive incorrect results when you run a complex query that contains aggregates functions, join functions, and distinct functions in subqueries in a SQL Server 2008 or SQL Server 2008 R2 environment
8207562588050FIX: Slipstream installation of a SQL Server 2008 or SQL Server 2008 R2 service pack fails when you add new features to the SQL instance if database engine is installed
9016892653857FIX: You cannot connect to SQL Server by using JDBC Driver for SQL Server after you upgrade to JRE 6 update 29 or a later version
8736032682488FIX: Backup operation fails in a SQL Server 2008, in a SQL Server 2008 R2 or in a SQL Server 2012 database after you enable change tracking
9589832719217FIX: Latch time-out error when you have heap tables and when data compression is enabled in SQL Server 2008 R2 or in SQL Server 2012



檔案下載:
Microsoft® SQL Server® 2008 R2 Service Pack 2
http://www.microsoft.com/en-us/download/details.aspx?id=30437

參考連結:
SQL Server 2008 R2 SP2 Is Now Available! http://blogs.msdn.com/b/sqlreleaseservices/archive/2012/07/26/sql-server-2008-r2-sp2-is-now-available.aspx

關鍵字:SQL ServerService PackSQL Server 2008R2

沒有留言:

張貼留言