Select the product you need help with
When you use a file handle for FileStream access in a SQL Server 2008 transaction, the transaction may randomly fail to commit in Windows Server 2003 or in Windows XP Professional x64 EditionArticle ID: 955280 - View products that this article applies to. On This PageSYMPTOMSOn a computer that is running Windows Server 2003 or Windows XP Professional x64 Edition, when you use the OpenSqlFilestream API or the .NET SqlFilestream class to obtain a file handle for FileStream access in a transaction in Microsoft SQL Server 2008, the transaction may randomly fail to commit. When this problem occurs, one of the following errors is logged in the SQL Server Errorlog file:
CAUSEThis problem occurs because of an error in the Server service. The Server service incorrectly delays closing the file handle. Therefore, SQL Server 2008 cannot perform commit operations. RESOLUTIONHotfix informationWindows Server 2003A supported hotfix is now available from Microsoft. However, it is intended to correct only the problem that is described in this article. Apply it only to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.To resolve this problem immediately, contact Microsoft Customer Support Services to obtain the hotfix. For a complete list of Microsoft Customer Support Services telephone numbers and information about support costs, visit the following Microsoft Web site: http://support.microsoft.com/contactus/?ws=support Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.
(http://support.microsoft.com/contactus/?ws=support)
PrerequisitesTo apply this hotfix, you must be running Windows Server 2003 Service Pack 1, Windows Server 2003 Service Pack 2, Windows XP Professional x64 Edition or Windows XP Professional x64 Edition Service Pack 2 on the computer.Restart requirementYou have to restart the computer after you apply this hotfix.Hotfix replacement informationThis hotfix does not replace a previously released hotfix.File informationThe English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.Windows Server 2003 with Service Pack 1, x86-based versions Collapse this table
Windows Server 2003 with Service Pack 1, x64-based versions Collapse this table
Windows Server 2003 with Service Pack 1, Itanium-based versionsCollapse this table
Windows Server 2003 with Service Pack 2, x86-based versions Collapse this table
Windows Server 2003 with Service Pack 2, x64-based versions Collapse this table
Windows Server 2003 with Service Pack 2, Itanium-based versions Collapse this table
Windows XP Professional x64 EditionA supported hotfix is now available from Microsoft. However, it is intended to correct only the problem that is described in this article. Apply it only to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.To resolve this problem immediately, contact Microsoft Customer Support Services to obtain the hotfix. For a complete list of Microsoft Customer Support Services telephone numbers and information about support costs, visit the following Microsoft Web site: http://support.microsoft.com/contactus/?ws=support Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.
(http://support.microsoft.com/contactus/?ws=support)
PrerequisitesTo apply this hotfix, you must be running Windows XP Professional x64 Edition or Windows XP Professional x64 Edition Service Pack 2 on the computer.Restart requirementYou have to restart the computer after you apply this hotfix.Hotfix replacement informationThis hotfix does not replace a previously released hotfix.File informationThe English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.Windows XP Professional x64 Edition Collapse this table
Windows XP Professional x64 Edition with Service Pack 2 Collapse this table
WORKAROUNDImportant This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base: 322756 Warning This workaround will cause a performance issue when you operating on shared files in the system.
(http://support.microsoft.com/kb/322756/
)
How to back up and restore the registry in WindowsTo work around this problem, set the value of the Cachedopenlimit registry entry to 0, and then restart the Server service. To do this, follow these steps:
Warning When you set the value to 0, file handles of all the shared files are not cached by the system. This can cause a performance issue when you are accessing shared files in the system. STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. MORE INFORMATIONThis problem also occurs in Windows Server 2008 and in Windows XP x86-based versions.
For more information about this problem in Windows Server 2008, click the following article number to view the article in the Microsoft Knowledge Base:
953263
For more information about this problem in Windows XP x86-based versions, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/953263/
)
When you use a Transact-SQL statement to operate on a FILESTREAM column in SQL Server 2008, the statement may randomly fail to commit and cause data corruption in Windows Server 2008
955567
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
-
(http://support.microsoft.com/kb/955567/
)
Data corruption may occur when you try to append data to a FILESTREAM varbinary (max) column in SQL Server 2008 on a Windows XP-based computer
824684
(http://support.microsoft.com/kb/824684/
)
Description of the standard terminology that is used to describe Microsoft software updates
When to use the FILESTREAM storageIn SQL Server 2008, binary large object (BLOB) data can be the data of the VARBINARY(MAX) type that stores data in database tables. BLOB data can also be the data of the VARBINARY(MAX) FILESTREAM type that stores the data in the file system. The data size and the data usage determine whether you should use the database storage or the FILESTREAM storage. You should consider using the FILESTREAM storage when the following conditions are true:
For more information, visit the following Microsoft Developer Network (MSDN) Web site: http://msdn.microsoft.com/en-us/library/bb933993.aspx
(http://msdn.microsoft.com/en-us/library/bb933993.aspx)
PropertiesArticle ID: 955280 - Last Review: October 8, 2011 - Revision: 3.0 APPLIES TO
|
Back to the top
