Backup on a mapped drive failing with Error 3201? The SQL Server service does not see the drive you mapped in Windows. Here is why, and what to do.
SQL SERVER – Error – Msg 6401, Level 16: Cannot roll back Transaction
Is there such a thing as nested transactions in SQL Server? A simple demo shows why rolling back a named inner transaction fails with Msg 6401.
SQL SERVER – FIX – A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running. (Microsoft.AnalysisServices.AdomdClient)
I opened SQL Server Management Studio and instead of a database engine. Below is the error which I received for SQL Browser:
Msg 864: Buffer Pool Extension Size Over the Limit
Msg 864 means a buffer pool extension file is larger than SQL Server allows for the memory in the machine. This post gives the limits, four read-only checks tested on SQL Server 2025, and the steps to start a server that will not boot.
SQL SERVER – FIX – Error: 905, Severity: 21, State: 1 – Database ‘xxx’ cannot be started in this edition of SQL Server because it contains a partition function ‘xxx’.
After moving from Enterprise Evaluation to Standard Edition, a database cannot be started in this edition because it uses a partition function. Here is the fix.
SQL SERVER – Installation Error – INSTALLSHAREDDIR parameter is not valid because this directory is compressed or is in a compressed directory
SQL Server setup failed saying the INSTALLSHAREDDIR parameter is not valid because the folder is compressed. Here is how removing that attribute fixes it.
SQL SERVER – Msg 8152, Level 16, State 14 – String or Binary Data Would be Truncated
Msg 8152, String or binary data would be truncated, is an error most developers have seen. Here is what causes it and why the setting that hides it needs care.