AlwaysOn Failover Bug

I just found a little bug in AlwaysOn. It’s actually not that big a deal, but it’s interesting. In a nutshell, if you have a table with an IDENTITY seed less than 1000, when you do a failover the table is reseeded to 1001. The steps to reproduce are posted on this Connect item. If you have feedback on this, please post it directly to the Connect item since I don’t think Microsoft reads my blog much.

5 thoughts on “AlwaysOn Failover Bug

  • Pat B.

    Grant,

    I realize that I arrived a little late for the party, but from one professional to another, thanks for having the Kahunas to take a stand on this issue. While I’m all for everyone having a good time, I have a hard time understanding how anyone who conducts themselves in the manner that you described could be referred to as an “MVP”…

  • Pat B.

    It was intended for the post on “Acceptable Behavior” but somehow misposted. Probably user error on my part…

Please let me know what you think about this article or any questions:

This site uses Akismet to reduce spam. Learn how your comment data is processed.