When the Filestream feature is enabled in SQL Server 2008, you receive a Stop error, and the computer restarts unexpectedly

Applies to: SQL Server 2008 EnterpriseSQL Server 2008 R2 Enterprise

Symptoms

Consider the following scenario:
  • You enable the Filestream feature in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2.
  • You use the Filestream feature to host data that is in a volume.
  • Either of the following conditions is true:
    • You enable the "Enable Quota Management" feature on the volume that contains the data.
    • You use third-party software that enables the quota driver on the volume that contains the Filestream data.
In this scenario, the computer may shut down or restart unexpectedly. Additionally, an event that resembles the following is logged in the System log:

Cause

This issue occurs because of how the Filestream RsFx driver handles certain flags on files that an application opens.

Workaround

To work around this issue, use the Fltmc.exe control program to unload the quota driver on the volume that the Filestream driver uses. To do this, follow these steps:
  1. At an elevated command prompt, type the following, and then press Enter:
    fltmc
  2. Verify that the Quota filter driver is displayed under Filter Name.
  3. Type the following command, and then press Enter:
    fltmc detach quota drive_letter:
  4. Type the following command, and then press Enter:
    fltmc unload quota
    Note This command unloads the quota driver on all volumes. Do not use this command if you want to use the Quota Management feature on volumes that do not contain Filestream data.

More Information

The following table provides more information about the products or tools that automatically check for this condition on your instance of SQL Server and on the versions of the SQL Server product against which the rule is evaluated.
Rule softwareRule titleRule descriptionProduct versions against which the rule is evaluated
System Center AdvisorSystem filter driver is detected that can cause stability problems for SQL Server Filestream featureSystem Center Advisor checks if the Filestream feature is enabled in an instance of SQL Server. Advisor also checks if quota management is enabled on the volumes that host the Filestream containers. If true, Advisor generates a message. Review the details that are provided in the “Information Collected” section of the advisor message, and follow the steps discussed in this article to resolve the message. SQL Server 2008

SQL Server 2008 R2




References

For more information about quota management, visit the following Microsoft TechNet website:
http://technet.microsoft.com/en-us/library/cc733029.aspx
For more information about the Filestream feature, visit the following Microsoft TechNet website:
http://technet.microsoft.com/en-us/library/bb933993.aspx