KB967351

A heavily fragmented file in an NTFS file system volume may not grow beyond a certain size because of limitations in structures that are used to describe the allocations.

In this scenario, you may experience one of the following issues:

  • When you try to copy a file to a new location, you receive the following error message:
    In Windows Vista or in later versions of Windows

    The requested operation could not be completed due to a file system limitation

    In versions of Windows that are earlier than Windows Vista

    insufficient system resources exist to complete the requested service

  • When you try to write to a sparse file from the Application log, Microsoft SQL Server may log an event that resembles the following:
    In Windows Vista or in later versions of Windows

    Event Type: Information
          Event Source: MSSQLSERVER
    
          Description: ...
          665(The requested operation could not be completed due to a file system limitation.) to SQL Server during write at 0x000024c8190000, in filename...

    In versions of Windows that are earlier than Windows Vista

    Event Type: Information
          Event Source: MSSQLSERVER
    
          Description: ...
          1450(Insufficient system resources exist to complete the requested service.) to SQL Server during write at 0x000024c8190000, in file with handle 0000000000000FE8 ...

Leave a Reply