SQL Server
SQL Server engine errors, backup and restore failures, availability groups and corruption checks.
70 articles
8152
Error 8152: String or Binary Data Would Be Truncated – Find the Column
Error 8152 hides which column overflowed on older builds. Use the SQL Server 2019 verbose message, or this query pattern,…
912
Error 912: Script Level Upgrade Failed After a Cumulative Update
Error 912 with 574 means an upgrade script failed and the instance is stuck. Start with trace flag 902, fix…
512
Error 512: Subquery Returned More Than One Value, and Related Query Failures
Error 512 means a scalar subquery matched several rows. Rewrite it with a join or TOP 1, and see how…
1603
MSI Error 1603 and 1618: SQL Server Tools and Update Installs Keep Failing
MSI error 1603 and 1618 usually mean another install is running or a cached MSI is missing. Clear the pending…
1205
Error 1205: Transaction Deadlocked on Lock Resources – Capture Then Cure
Error 1205 kills one session to break a lock cycle. Capture the graph from the system_health session, then fix index…
17051
Error 17051: The SQL Server Evaluation Period Has Expired – What To Do Now
Error 17051 stops the service dead 180 days after install. The only real fix is an edition upgrade with a…
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…