Friday, July 27, 2012

FileTable with AlwaysOn AGs – Bug

After a long while of testing and troubleshooting we identified two bugs in SQL Server that can hit you if you run FileTables in conjunction with AlwaysOn Availability Groups. One concerns the way Checkpoints are done in FileStream, which could lead to very long failover times, the other one concerns a handle issue that could lead to the system running out of sync without noticing.

Right now there is no feasible workaround to both problems, but Microsoft has already confirmed that both issues will be fixed in Service Pack 1.

If you should encounter this problem and need help working around it please ping me and I will share the necessary details.


  1. Hi, please could you share the details to me

  2. Hello, could you provide me with reports on this, I am thinking of implementing it in SQL Server 2017, my email is