• 2TB is the maximum possible size for a transaction log file, so unrestricted and limited to 2TB are exactly the same. It's not a side effect of file streams.

    Restricted size has nothing to do with the file not shrinking. The log file will not shrink automatically, no file will. If you really have a good reason to shrink, you do it manually, but it's not something you want to do often.

    p.s. Auto growth should not be set to a %, it should be set to a fixed size in MB.

    p.p.s. Log files aren't in primary, they're not part of any filegroup. Filegroups are sets of data files only.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass