AlwaysOn Failover Bug

Home / SQL Server 2012 / 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.


  • Pat B.


    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…

OK, fine, but what do you think?