system AI diagnostic case

Windows 11 25H2 SQL Server FILESTREAM Garbage Collection Not Running

This diagnostic guide helps identify why SQL Server FILESTREAM garbage collection is not executing on Windows 11 version 25H2. FILESTREAM garbage collection is essential for cleaning up unreferenced FILESTREAM data and maintaining storage health. Issues can arise due to service misconfiguration, permission problems, or system-level changes introduced in Windows 11 25H2.

Describe your Windows problem
Read-only diagnostic first. No repair without review.

Symptoms

  • Accumulation of orphaned FILESTREAM data on disk
  • FILESTREAM garbage collection job does not run as scheduled
  • Increased disk usage in SQL Server FILESTREAM filegroups
  • No related errors or warnings in SQL Server error logs

Likely causes

  • SQL Server Agent service not running or misconfigured
  • FILESTREAM garbage collection internal job disabled or failing silently
  • Windows 11 25H2 system changes affecting FILESTREAM cleanup tasks
  • Insufficient NTFS permissions on FILESTREAM directory preventing cleanup

What FixWin checks

  • Verify SQL Server Agent service is running and set to automatic
  • Check SQL Server error logs for FILESTREAM garbage collection related messages
  • Confirm FILESTREAM feature is enabled in SQL Server configuration manager
  • Inspect Windows Event Viewer for related warnings or errors under Application logs
  • Validate NTFS permissions on FILESTREAM data directories for SQL Server service account

AI diagnostic workflow

  • Open Services.msc and ensure 'SQL Server Agent (MSSQLSERVER)' is running
  • Review SQL Server error logs via SQL Server Management Studio under Management > SQL Server Logs for GC entries
  • Run SQL query to check if FILESTREAM garbage collection is enabled: SELECT is_filestream_gc_enabled FROM sys.database_filestream_options
  • Use Event Viewer to identify any system or application errors related to FILESTREAM or SQL Server Agent
  • Check folder permissions on FILESTREAM data storage path to ensure SQL Server service account has full control

Related Windows entities

  • SQL Server Agent service
    Runs scheduled jobs including FILESTREAM garbage collection tasks essential for cleanup.
  • SQL Server Error Log log
    Contains detailed messages about FILESTREAM garbage collection status and potential errors.
  • Event Viewer - Application Log log
    Logs system and application events that may indicate permission or service failures affecting FILESTREAM GC.
  • SQL Server Configuration Manager tool
    Used to verify and enable FILESTREAM feature settings on SQL Server instance.
  • NTFS File System Permissions component
    Proper permissions are required on FILESTREAM data directories for cleanup operations to succeed.

Repair logic

Diagnose by confirming SQL Server Agent service is operational and FILESTREAM feature is enabled. Review logs for errors and verify permissions on FILESTREAM data folders. Address any service startup issues or permission denials found. Windows 11 25H2 changes may require validating compatibility or applying relevant updates or patches from Microsoft to ensure FILESTREAM garbage collection jobs run as expected.

FAQ

Why is FILESTREAM garbage collection important?

It removes unreferenced FILESTREAM data from disk to reclaim storage and maintain database health.

How do I check if FILESTREAM garbage collection is enabled?

Run the SQL query: SELECT is_filestream_gc_enabled FROM sys.database_filestream_options in your SQL Server database.

Can Windows 11 25H2 updates affect SQL Server FILESTREAM functionality?

Yes, system updates can impact service behaviors or permissions, potentially interfering with FILESTREAM cleanup jobs.

Related Windows problems

Fix this Windows problem automatically

Start a private FixWin diagnostic session for: Windows 11 25H2 SQL Server FILESTREAM Garbage Collection Not Running