Article ID: 231347 - View products that this article applies to.
This article was previously published under Q231347
Microsoft SQL Server databases are not supported on NTFS or FAT compressed volumes. A compressed volume does not guarantee sector-aligned writes which is needed to guarantee transactional recovery in some circumstances.
Although it is physically possible to add SQL Server databases on compressed volumes, we do not recommend it, and we do not support it. The underlying reasons for this include the following:
On Windows Vista and on later versions of Windows
On earlier versions of Windows
STATUS_FILE_SYSTEM_LIMITATION The requested operation could not be completed due to a file system limitation
Operating system error 665(The requested operation could not be completed due to a file system limitation)
For more information about this issue, see the following article in the Microsoft Knowledge Base:
STATUS_INSUFFICIENT_RESOURCES insufficient system resources exist to complete the requested service
Operating system error 1450(Insufficient system resources exist to complete the requested or 33(The process cannot access the file because another process has locked a portion of the file.)
(http://support.microsoft.com/kb/967351)A heavily fragmented file in an NTFS volume may not grow beyond a certain size
For more information about the exclusions for read-only databases and for read-only file groups in SQL Server 2005, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn.microsoft.com/en-us/library/ms190257(SQL.90).aspxFor more information about the exclusions for read-only databases and for read-only file groups in SQL Server 2008, visit the following MSDN Web site:
SQL Server requires systems to support 'guaranteed delivery to stable media' as outlined under the Microsoft SQL Server Always-On Storage Solution Review program. For more information about the input and output requirements for the SQL Server database engine, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/967576/ )Microsoft SQL Server Database Engine Input/Output Requirements
Article ID: 231347 - Last Review: July 20, 2012 - Revision: 7.0
Contact us for more help
Connect with Answer Desk for expert help.