Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

View products that this article applies to.

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:

↑ Back to the top

Cause

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

↑ Back to the top

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.

↑ Back to the top

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




↑ Back to the top

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

↑ Back to the top

Keywords: kbprb, kbsurveynew, kbtshoot, kbentirenet, kb

↑ Back to the top

Article Info
Article ID : 2678763
Revision : 1
Created on : 1/7/2017
Published on : 3/21/2012
Exists online : False
Views : 226