Filestream

Disable-DbaFilestream

Stuart Moore (@napalmgram) | Chrissy LeMaire (@cl)

Disable-DbaFilestream View Source Stuart Moore (@napalmgram) , Chrissy LeMaire (@cl) Windows, Linux, macOS Synopsis Disables SQL Server FileStream functionality at both the service and instance levels Description Disables the FileStream feature completely by setting the FilestreamAccessLevel configuration to 0 (disabled) and modifying the corresponding Windows service settings. This is useful when FileStream was previously enabled but is no longer needed, during security hardening, or when troubleshooting FileStream-related issues. The function handles both standalone and clustered SQL Server instances, automatically detecting cluster nodes and applying changes across all nodes.

Enable-DbaFilestream

Stuart Moore (@napalmgram) | Chrissy LeMaire (@cl)

Enable-DbaFilestream View Source Stuart Moore (@napalmgram) , Chrissy LeMaire (@cl) Windows, Linux, macOS Synopsis Configures FILESTREAM feature at both instance and server levels on SQL Server Description Configures SQL Server’s FILESTREAM feature by setting the FilestreamAccessLevel at the instance level and enabling the Windows service component at the server level. The function supports three access levels: T-SQL only, T-SQL with I/O streaming, or T-SQL with I/O streaming and remote client access.

Get-DbaFilestream

Stuart Moore (@napalmgram) | Chrissy LeMaire (@cl)

Get-DbaFilestream View Source Stuart Moore (@napalmgram) , Chrissy LeMaire (@cl) Windows, Linux, macOS Synopsis Retrieves FileStream configuration status at both the SQL Server service and instance levels. Description Retrieves FileStream configuration status by checking both the SQL Server service configuration and the instance-level sp_configure settings. This function helps DBAs quickly identify FileStream configuration mismatches between service and instance levels, which are common causes of FileStream functionality issues. The function returns detailed access levels, share names, and indicates whether a restart is pending to apply configuration changes.