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.
