In the previous post we saw the compatibility of new features like TDE, FILESTREAM and Compression with High Availability (HA) options. Now we continue the compatibility matrix with other existing features.

Note: Sql Server does not support Database Snapshot for FILESTREAM filegroups. But you can create Database Snapshot for the rest of the non-FILESTREAM filegroups. If you try to query FILESTREAM data from the Database Snapshot you get the following error.

Could not continue scan with NOLOCK due to data movement.

When you look at any set of features compared in a matrix like this, it gets easier to remember.

In future, I will try to add details about each matrix cell.

Hope this helps,
_SqlTimes