SQL Server
SQL Server engine errors, backup and restore failures, availability groups and corruption checks.
70 articles
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…
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…
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…
40615
Error 40615 and 40613: Azure SQL Firewall Blocks and Unavailable Databases
Error 40615 blocks your client IP at the Azure SQL firewall while 40613 means the database is not online yet.…
823
Errors 823, 824 and 825: I/O Errors That Signal Real Storage Damage
Error 823 is a hard OS I/O failure and 824 is a page that came back wrong. Both mean check…
8909
Error 8909 and DBCC CHECKDB Allocation Errors: Repair Without Losing Rows
Error 8909 and its 89xx relatives mean CHECKDB found structural damage. Learn the safe order: backup, isolate, restore, then repair…
605
Error 605: Page Belongs to the Wrong Allocation Unit – Corruption or Dirty Read
Error 605 means two opposite things. Severity 21 is real page corruption; severity 12 is transient, from a dirty read…
8992
Error 8992 and CHECKCATALOG Failures: System Metadata Is Inconsistent
Error 8992 with Msg 3852 or 3853 means system table rows no longer agree. See why DBCC repair cannot fix…
