Database snapshot "The requested operation could not be completed due to a file system limitation"
The issue is around NTFS allocation maps and the amount of space they have for file allocations. In general, the more fragmented the file the more allocation mappings there needs to be.

By default when a volume is formatted for NTFS, small allocation map size is chosen (1024 bytes) whereas with /L the large allocation map size is chosen (4096 bytes).

Normally this doesn't come into play or show itself and any appreciable way... However once volumes get larger and larger or use technologies that create many small random allocations (such as database snapshots or checkdb) then it can rear its' ugly head.

To get around this, a few different options can be chosen:


Format the volume ntfs with /L:Enable
Make smaller volumes so that this doesn't happen
Use ReFS if on SQL 2014+


In most cases, choosing to format with /L:Enable will be the easiest and fastest option.