Advertisements
Home > SQL 2012 > Corruption occurs on the page of secondary replica when you change the secondary replica to unreadable

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

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
  1. Chris Wood
    May 20, 2015 at 9:02 am

    Mohit,

    Do you have an idea at what level was this issue discovered? Is it an SP2 only issue or maybe introduced in a CU post SP2?

    Thanks

    Chris

  2. May 20, 2015 at 10:07 am

    Hey Chris,

    I do not know when it was introduced top of my head. I will look into it and circle back either later today or by end-of-day tomorrow.

    Thanks.

  3. May 20, 2015 at 10:25 am

    To complete circle here, for other readers. Chris confirmed this with Bob Ward (Principal Architect Escalation Engineer, Microsoft CSS) this issue has been present since SQL 2012 RTM. Guess the combination of Compression + AlwaysOn Secondaries that are readable has not been tried to date.

    — Thanks Chris/Bob 🙂

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: