SQL Server
SQL Server engine errors, backup and restore failures, availability groups and corruption checks.
70 articles
976
Error 976: The Target Database Is Not Available on a Readable Secondary
Error 976 means the replica is not configured for read access, and 35250 means the connection to the primary is…
4305
Errors 4305 and 4326: Log Backups Out of Sequence in a Restore Chain
Error 4305 means a log backup is too recent and 4326 means it is too early. Rebuild the LSN chain…
41131
Error 41131: Failed to Bring the Availability Group Online
Error 41131 is a timeout bringing the group online. Microsoft's documented cause is a missing NT AUTHORITY\SYSTEM login; 35222 is…
33111
Error 33111: Cannot Find Server Certificate When Restoring a TDE Backup
Error 33111 means the TDE certificate that protected the backup is missing here. Restore the certificate and private key before…
1418
Error 1418: The Mirroring Server Network Address Cannot Be Reached
Error 1418 means the partner endpoint is unreachable or not started. Verify the endpoint port, its state, service account rights…
9002
Error 9002: The Transaction Log Is Full – Find the log_reuse_wait Reason
Error 9002 is a symptom, not a cause. Query log_reuse_wait_desc to see whether backups, replication or an open transaction is…
1412
Error 1412: The Remote Copy Has Not Been Rolled Forward Far Enough
Error 1412 means the mirror is missing log backups taken since the last restore. Apply the outstanding log chain with…
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…