SQL Server
SQL Server engine errors, backup and restore failures, availability groups and corruption checks.
70 articles
3202
Error 3202 and 3271: Backup Write Failures and Nonrecoverable I/O Errors
Error 3202 usually means the disk filled mid-backup, while 3271 signals a real I/O fault. Size the target, check the…
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…
3241
Error 3241: The Media Family on Device Is Incorrectly Formed
Error 3241 means the file is not a valid backup set for this restore: a partial copy, a striped set…
14274
Error 14274: Jobs Break After a Server Rename or an MSX Move
Error 14274 blocks job edits when originating_server no longer matches the instance name. Learn the supported fix after a rename,…
3154
Error 3154: The Backup Set Holds a Backup of a Different Database
Error 3154 stops you overwriting the wrong database. Learn when WITH REPLACE is safe, when MOVE is required and how…
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…
