I moved TempDB files and SQL Server would not start, with OS Error 5 (Access is denied). The message was misleading, and here is the real mistake.
SQL SERVER – Mirroring Error: Connection handshake failed. Could not send a handshake message because the connection was closed by peer. State 26
A mirroring error, connection handshake failed, State 26. The checks I once asked readers for, run on SQL Server 2025 on a real endpoint.
SQL SERVER – FIX : Msg 3178, Level 16 – File SQLAuthority is Not in the Correct State to have This Differential Backup Applied to it
Msg 3178 says a file is not in the correct state to have this differential backup applied to it. Here is how I reproduced it, and the fix.
SQL SERVER – FIX : Msg 8115, Level 16, Arithmetic Overflow Error Converting IDENTITY to Data Type INT
A SharePoint check-in failed with Msg 8115, Arithmetic Overflow Error converting IDENTITY to data type INT. How I found the table with Profiler and fixed it.
Why SELECT HOST_NAME() Returns Empty String? – Interview Question of the Week #119
Question: Why SELECT HOST_NAME() Returns Empty String while connected from certain .net application?
SQL SERVER – FIX: Msg 3132, Level 16 – The Media Set has 2 Media Families but Only 1 are Provided. All Members Must be Provided
RESTORE failed with Msg 3132: the media set has 2 media families but only 1 are provided. A repro of this striped backup error and how to restore correctly.
SQL SERVER – Service Pack Error – Index (Zero Based) Must be Greater Than or Equal to Zero and Less Than the Size of the Argument List
A service pack failed with: Index (zero based) must be greater than or equal to zero and less than the size of the argument list. Here is what I found.