Restoring to an NTFS compressed folder fails.
Errors: Msg 61700, Level 16, State 1, Line 0 Unexpected termination on thread: 1, Return code: x2DB4 RESTORE DATABASE is terminating abnormally. Write on "???" failed: 665(The requested operation could not be completed due to a file system limitation)
The same filesrestores as normal read-write databases.
Is there any way to update Windows 2008/R2 or Windows 7 with the 2012 functionality that prevents a failed compression?
Windows versions, other than Windows Server 2012 and Windows 8, have an operating system limitation with NTFS Compression. The limits vary based on compression characteristics of the files. Hard limits cannot be determined, but 100GB may be close to the top end for many databases.
When a file is compressed it is split up into 64kb 'compression units', then each unit is evaluated for compression. When we get close to the limit for single file fragmentation, we stop evaluating the compression units. So it never reaches the limit. The file can get bigger, but it won't get anymore fragmented.
This is a limitation of Microsoft Windows, not a LiteSpeed failure.
There is no way to update Windows 2008/R2 or Windows 7 with the 2012 functionality, as its too big an architectural change to back port to 2008, It is not possible to update 2008/2008R2/Win 7 with the 2012 functionality. But Is there is a way you can get around the issue in older versions. If they have the updates to NTFS installed, they can format with the /L switch. This will create 4k file records instead of the old style 1k records. This will allow you to have as much as 4X as much fragmentation without hitting the limit.
