Search This Blog

Sql Server 2008 new features Compression, FILESTREAM and TDE compatibility with with all High Availability (HA) options

Some of the new features in Sql Server 2008 are very useful (and long over due). Features like
  • Compression
  • FileStream
  • TDE (Transparent Data Encryption).
Though they have their own limitations, they are very useful when available natively.
Here we’ll look into their compatibility with existing High Availability (HA) features.
  • FailOver Clustering
  • Database Mirroring
  • Replication
  • Log Shipping
Lets start with the matrix, and then we’ll go into details:
Compression
FileStream
TDE
FailOver Clustering
Y
Y
Y
Database Mirroring
Y
No
Y
Replication
Y
Y
Y
Log Shipping
Y
Y
Y
When you look at it this way, it makes it much easier to remember all the options. Of all, as you can see, only one stand out i.e. FileStream is not configurable in Database Mirroring. All the other configurations are fairly well supported. Please know that there are, in fact, some limitations for these features in each HA implementation (but, that is for an article some other day).
Hopefully, future versions of Sql Server will support FileStream in Database Mirroring.