Return
-
Title
LiteSpeed Maintenance plan cleanup history fails with error code 0xC002F210 - SQL 2022 -
Description
Cleanup history step errors when LiteSpeed runs on SQL 2022 -
Cause
SQL Server 2022 does not include ODBC driver as part of the setup. The ODBC driver is a LiteSpeed pre-requisite.
-
Resolution
Install SQL Native Client 12
https://www.microsoft.com/en-US/download/details.aspx?id=50402?1558859051
-
Additional Information
Workaround: Edit the current maintenance plan Disable Cleanup history step Add exec T-SQL step with command exec [LiteSpeedLocal]..[LiteSpeed_DeleteActivity] @delLocal=1,@purgeDeleted=1, @delLogshipping=1, @delStatus=1, @delUnit=3, @delUnitType='DAYS' In the example above history older than 3 days will be purged. (@delUnit=3) These arguments can be configured as desired: @delUnit= Any integer @delUnitType='[HOURS, DAYS, WEEKS, MONTHS, YEARS]'
