2008年使用文件流数据,但小心……

SQL Server 2008的特性之一是文件流数据的特性。在以前的版本中,我们必须决定存储BLOB数据之间完全内部完全数据库或外部。现在我们有两个世界最好的东西。让我们创建无限列的大小。但小心,不兼容的SQL Server ....每个特性例如,数据库镜像和文件流数据不兼容。你会得到一个错误当试图形成镜子伙伴关系。同时,尽管您可以创建一个数据库,文件流数据快照,Filestream Filegroup本身并不兼容快照。透明数据加密的数据库,但它不加密文件流数据。你觉得这个特性在隔离了吗? OK, let's balance things out. Replication supports Filestream data. Log Shipping supports it. So does Failover Clustering, as long as the data is on a shared disk. Full Text Indexes work with Filestream columns. Even SQL Server Express supports it and the 4GB database limit does not include the Filestream data. As always, there's good news and bad news. But that's not SQL Server, that's life. cheers Brian Using FILESTREAM with Other SQL Server Features: http://msdn.microsoft.com/en-us/library/bb895334.aspx