徵狀
假設您在 Microsoft SQL Server 2012、2014或2016中,將資料庫的 目標恢復時間 設為非零值。 如果在檢查點處理期間發生斷言,則斷言會在資料庫上產生租約超時,而且您會收到下列 dump 檔案:
date time spid14s Error: 17066, Severity: 16, State: 1. date time spid14s SQL Server Assertion: File: <recoveryunit.cpp>, line=7849 Failed Assertion = 'm_ReducedDataSlice <= MaxReducedDataSlice'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.date time spid14s Error: 3624, Severity: 20, State: 1.date time spid14s A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a Hotfix from Technical Support. date time spid14s Error: 18400, Severity: 16, State: 1. date time spid14s The background checkpoint thread has encountered an unrecoverable error. The checkpoint process is terminating so that the thread can clean up its resources. This is an informational message only. No user action is required.
解決方案
此問題已在 SQL Server 的下列累積更新中修正:
SQL Server 2012 累積更新 7 Service Pack 3
SQL Server 2014 累積更新 3 Service Pack 2
SQL Server 2014 的累積更新 10 Service Pack 1
關於 SQL Server 的累計更新
每個新的 SQL Server 累計更新都包含所有的修正程式,以及前一個累積更新中所包含的所有安全性修正程式。 查看 SQL Server 的最新累計更新: Sql server 2012 的最新累計更新 SP3
因應措施
若要解決此問題,請將受影響資料庫的目標恢復時間設定為零。
狀態
Microsoft 已確認<適用於>一節中所列的 Microsoft 產品確實有上述問題。
參考
瞭解 Microsoft 用於描述軟體更新的 術語 。