SQL Server
SQL Server engine errors, backup and restore failures, availability groups and corruption checks.
70 articles
9001
Error 9001: The Log for the Database Is Not Available After a Crash
Error 9001 with 9003 or 9004 means SQL Server cannot read or replay the log. See what redo errors 3313…
20598
Error 20598: The Row Was Not Found at the Subscriber When Applying Commands
Error 20598 means the distribution agent tried to change a row that is missing downstream. Reconcile the data properly instead…
3967
Error 3967: Insufficient Space in tempdb to Hold Row Versions
Error 3967 and 3958 mean the version store filled tempdb under snapshot isolation. Find the long transaction holding versions and…
17113
Error 17113: SQL Server Cannot Find or Open master.mdf at Startup
Error 17113 with 17204 or 5120 means the engine cannot open its own files. Check the -d startup parameter, the…
3414
Error 3414 and 3417: Recovery Failed and the Instance Will Not Start
Error 3417 stops the whole instance while 3414 kills a single database. Learn the rebuild path for master and the…
17182
Error 17182: TDSSNIClient Initialisation Failed and the Port Never Opens
Error 17182 means SQL Server started but could not bind its network endpoint. Check port conflicts, the TLS certificate and…
18401
Error 18401 and 17187: SQL Server Is Not Ready to Accept Connections
Error 18401 and 17187 mean the engine is up but still upgrading or recovering. Learn how to watch recovery progress…
1069
Service Error 1069 and 17058: The SQL Server Account Cannot Start the Instance
Service error 1069 is a logon failure and 17058 means the error log cannot be written. Reset the service account…
15404
Error 15404: Could Not Obtain Information About Windows Group or User
Error 15404 fails a job because SQL Server cannot resolve its owner in Active Directory. Reassign ownership to sa and…
22050
Error 22050: Database Mail Fails to Format or Send the Query Results
Error 22050 usually means sp_send_dbmail parameters or permissions are wrong, not the SMTP server. Check the query, the profile and…
3201
Error 3201: Cannot Open Backup Device – Permissions and Path Problems
Error 3201 with operating system error 5 means the service account, not you, cannot reach the path. Fix share and…
14421
Errors 14420 and 14421: Log Shipping Backup and Restore Alerts Firing
Error 14421 means the secondary is behind its restore threshold and 14420 means backups stopped on the primary. Diagnose the…