I walked into a client engagement where I really got stuck with a very interesting scenario with a client with PREEMPTIVE_OS_RSFXDEVICEOPS Wait Type.
SQL SERVER – FIX: Error: 5511 – FILESTREAM’s file system log record under log folder is corrupted
Error 5511 says the FILESTREAM file system log record under the log folder is corrupted. Here is how I got the database back online.
SQL SERVER – Slow Filestream Data Cleanup. What Should We Do?
Slow Filestream Data Cleanup can follow deletion when files are still ineligible for garbage collection. One customer was running out of space.
SQL SERVER – Script Upgrade Failure – RsFxFt.Dll::RsFxMgmtInitialize failed: Error 0x80070002
A script upgrade failure left SQL Server down with RsFxFt.Dll error 0x80070002 and error 5597. Tested on SQL Server 2025: the FILESTREAM cause.
SQL SERVER – Rule Windows Server 2003 FILESTREAM Hotfix Check failed on Windows 2012 R2 Cluster
SQL Server 2008 R2 setup failed on a Windows 2012 R2 Cluster with rule ‘Windows Server 2003 FILESTREAM Hotfix Check’. What the setup log showed and the fix.
FileTable: Files You Can Open in Explorer and Query in T-SQL
Set up FileTable prerequisites, create a Windows-accessible file namespace, query stored file metadata, and compare simpler path storage.
SQL SERVER – Working with FileTables in SQL Server 2012 – Part 3 – Retrieving Various FileTable Properties
Part 3 of my FileTables series for SQL Server 2012: queries to tell files from folders and find root paths, path locators and relative paths.