SQL Server
SQL Server engine errors, backup and restore failures, availability groups and corruption checks.
70 articles
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…
1827
Error 1827: SQL Server Express Has Hit Its Licensed Database Size Limit
Error 1827 means the database cannot grow past the size Express is licensed for - 10 GB up to SQL…
701
Error 701: Insufficient System Memory on a Memory-Capped SQL Server Edition
Error 701 and 802 mean the buffer pool is exhausted. On Express the 1410 MB ceiling is a licence limit,…
905
Error 905 and 909: The Database Uses Features Your Edition Does Not Have
Error 905 and 909 stop a database starting on a lower edition because it uses partitioning or compression. See which…
948
Error 948 and 946: The Database Was Created by a Newer SQL Server Version
Error 948 and 946 mean the file or backup comes from a newer build. Downgrade is unsupported, so license the…
22022
Error 22022: SQLServerAgent Is Not Currently Running, or Does Not Exist
Error 22022 means Agent is stopped, or on Express absent entirely because the edition has no scheduler. Confirm which case…
17809
Error 17809: The Maximum Number of User Connections Has Been Reached
Error 17809 means the user connections setting is capped or exhausted. Raise it with sp_configure, fix pool leaks and check…
20011
Error 20011 and 20084: Replication Agent Failures and Rejected Subscriptions
Error 20011 is the outer line on a failed replication agent; the cause is the inner error in agent history.…
8645
Error 8645: Memory Grant Timeouts Against the Standard Edition Memory Cap
Error 8645 and 8657 mean queries queue for memory that never frees. On Standard the buffer pool cap is a…
18752
Error 18752: Only One Log Reader Agent Can Connect to the Database
Error 18752 means two log readers or a stale session are fighting over one published database. Clear the orphaned agent…
40544
Error 40544: The Azure SQL Database Has Reached Its Size Quota
Error 40544 and the 4055x session kills mean the service tier ran out of headroom. See which limit you hit,…
