Return
-
Title
The query processor ran out of stack space during query optimization" error is encountered when creating a backup of a database with many filegroups. -
Description
The query processor ran out of stack space during query optimization" error is encountered when creating a backup of a database with many filegroups.
Replication steps -
- Create a large number of file groups (the issue starts manifesting at above 2000-2200 on current dev machines, but it varies with available memory)
- Perform a backup of this database
- The backup “The query processor ran out of stack space during query optimization. Please simplify the query.” error is encountered
The error is visible in LiteSpeed logs.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.