SQL Server
SQL Server engine errors, backup and restore failures, availability groups and corruption checks.
70 articles
833
Error 833: I/O Requests Taking Longer Than 15 Seconds on Your Storage
Error 833 and 845 are early warnings that storage cannot keep up. Correlate with latch waits and scheduler errors 17883…
0xC020801C
SSIS Error 0xC020801C: Cannot Acquire Connection From Connection Manager
Error 0xC020801C means the package could not open a connection at run time. Check the protection level, stored passwords and…
0xC02020A1
SSIS Error 0xC02020A1: Data Conversion and Truncation Failures in a Data Flow
0xC02020A1 means a column value would not convert. Read the status text it carries, then fix the column width, the…
0xC0047062
SSIS Error 0xC0047062: Packages Fail as Agent Jobs but Run in Visual Studio
0xC0047062 carries a managed component's own exception. Read that exception, then line up bitness, providers and the proxy account with…
8623
Error 8623: The Query Processor Ran Out of Internal Resources
Error 8623 means the query is too complex to compile, usually a huge IN list or generated SQL. Simplify or…
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.…
