FIX: Error 832 occurs after you apply update MS14-044 to SQL Server 2008 R2 or SQL Server 2008

Applies to: SQL Server 2008 R2 Service Pack 2SQL Server 2008 R2 EnterpriseSQL Server 2008 R2 Developer

Symptoms


Consider the following scenario:
  • You have applied security update MS14-044to Microsoft SQL Server 2008 R2 Service Pack 2 (SP2) or Microsoft SQL Server 2008 SP4.
  • Your database has Full-Text Search catalogs.
  • You have a numeric column in a table and that column is used as the index key for the Full-Text Search indexes.
In this scenario, the following database corruption error 832 may be reported in the SQL Server error log:
Error: 832, Severity: 24, State: 1.

A page that should have been constant has changed (expected checksum: <expected value>, actual checksum: <actual value>, database <dbid>, file '<filename>', page <pageno>). This usually indicates a memory failure or other hardware or OS corruption.
Note Error 832 is one of the symptoms. You may encounter various other symptoms such as access violations, asserts that depends on the extent of the issue.

Resolution


Hotfix for SQL Server 2008 SP4

To resolve this issue, apply KB 3034373: An on-demand hotfix update package is available for SQL Server 2008 SP4 .

Hotfix for SQL Server 2008 R2 SP3

To resolve this issue, apply the hotfix that is described in KB 3033860 An on-demand hotfix update package is available for SQL Server 2008 R2 SP3 .

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.