Tag: SQL Server Errors
-
SQL Server Error Severities Explained
🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. ⚡Read the Level before you read the message. 0 to 10 is informational, 11 to 16 means the statement is wrong and the server is fine, 17 to 19 is resource pressure and it is yours to investigate, and 20…
Written by
-
SQL Server: ALTER DATABASE SET ENABLE_BROKER Taking a Long Time (Fix)
After a recent Availability Group failover, Database Mail stopped sending emails. On investigation, the underlying cause was Service Broker not being enabled on msdb, the system database Database Mail runs out of. Enabling it should be instant. Instead the statement sat there, and this is what it was waiting on. To confirm the status, I…
Written by
-
SQL Server: Ad hoc Update to System Catalogs is Not Supported (Fix)
While enabling show advanced options using sp_configure, I encountered an unexpected failure when executing RECONFIGURE: The change would not apply, and any further configuration attempts failed in the same way. This issue typically appears on systems where older configuration settings have been modified and never reset. In most cases, the root cause is the legacy…
Written by
-
SSMS Certificate Chain Not Trusted Error (Trust Server Certificate Fix)
🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. If you have upgraded SSMS or a driver recently and a connection that worked yesterday has stopped working today, this is almost certainly what you are looking at. Nothing changed on the server. The client got stricter, and it is…
Written by
-
Database Cannot Be Opened – It Is in the Middle of a Restore
🚨Part of the SQL Server Errors series, the exact messages and what actually causes them. You may see this error when trying to access a database during or after a restore: Msg 927 · Level 14 · State 2 Database ‘YourDb’ cannot be opened. It is in the middle of a restore. ⚡Run the first…
Written by
- Set the Default Database for a SQL Server Login
- SQL Server High CPU: What to Check First, in Order
- Cannot Connect to SQL Server: The Checks in the Order That Finds It
- Cumulative Wait Stats Lie: Measuring Waits Over an Interval
- SQL Server Differential vs Log Backup: Which One Restores What, and How the Chain Breaks
- SQL Server MAXDOP and Cost Threshold: What To Set, and Why 5 Is Not a Recommendation
- Backups & Recovery (17)
- DBA Scripts (150)
- High Availability (HA) (12)
- Installation & Configuration (45)
- Maintenance (24)
- Migration & Upgrades (14)
- Monitoring (9)
- Performance Tuning (37)
- Security (Encryption & Permissions) (19)
- Storage & Capacity (14)
- T-SQL Fundamentals (11)
- Troubleshooting (65)
- Wait Types (235)