•  
  • Archives for January 2017 (1)

AlwaysON RECOVERY PENDING SQL Server Bugs Enhancement Requests T-SQL Tuesday

by Muthukkumaran kaliyamoorthy Published on: January 11, 2017
Comments: No Comments
Tags:
Categories:AlwaysON, SQL party

This month’s T-SQL Tuesday topic is “SQL Server Bugs & Enhancement Requests” and hosted by my favorite and inspirational Brent Ozar.

 

 

Here is my bug report:

https://connect.microsoft.com/SQLServer/feedback/details/3022019 and it is still in active.

It happen one of my production database, when I tried to remove the database from alwaysON and other important databases went recovery pending and inaccessible. I have no idea what happened to all other databases, then I came to know it is a bug.

 

The issue is when the database removed from the primary replica, with the secondary disconnection the higher database IDs on the secondary went into “NOT SYNCHRONIZED and RECOVERY PENDING” state, but the lower database IDs are good and synchronous state only.

http://www.sqlserverblogforum.com/2016/08/alwayson-database-not-synchronized-and-recovery-pending/

Muthukkumaran kaliyamoorthy

I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server And I’m specialized in Administration and Performance tuning. I’m an active member of SQL server Central and MSDN forum. I also write articles in SQL server Central. For more Click here

More Posts - Website

page 1 of 1

Welcome , today is Sunday, June 25, 2017