Advertisements

Archive

Posts Tagged ‘Corruption’

Corruption occurs on the page of secondary replica when you change the secondary replica to unreadable

May 19, 2015 3 comments

Corruption issue should be treated as critical, as if gone undetected they are difficult to recover from without data loss.

The corruption can happen when changing readability property of the secondary database.  However only if the database is using data compression.  Please review and test the linked CUs if you are using AlwaysOn Availability Groups and Data Compression with your environment.

Microsoft SQL Server 2012 SP2 CU6 (link) and Microsoft SQL Server 2012 SP1 CU16 (link) released.

Advertisements
%d bloggers like this: