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.
This issue occurs because of how the Filestream RsFx driver handles certain flags on files that an application opens.
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:
- At an elevated command prompt, type the following, and then press Enter:fltmc
- Verify that the Quota filter driver is displayed under Filter Name.
- Type the following command, and then press Enter:fltmc detach quota drive_letter:
- Type the following command, and then press Enter:fltmc unload quotaNote 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.
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 software||Rule title||Rule description||Product versions against which the rule is evaluated|
|System Center Advisor||System filter driver is detected that can cause stability problems for SQL Server Filestream feature||System 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
For more information about quota management, visit the following Microsoft TechNet website: