LiteSpeed Maintenance plan cleanup history fails with error code 0xC002F210

Chat now with support

LiteSpeed Maintenance plan cleanup history fails with error code 0xC002F210 - SQL 2022 (4376875)

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

LiteSpeed Maintenance plan cleanup history fails with error code 0xC002F210 - SQL 2022
Beschreibung

Cleanup history step errors when LiteSpeed runs on SQL 2022
Ursache

SQL Server 2022 does not include ODBC driver as part of the setup. The ODBC driver is a LiteSpeed pre-requisite.
Lösung

Install SQL Native Client 12

https://www.microsoft.com/en-US/download/details.aspx?id=50402?1558859051
Weitere Informationen

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]'

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

LiteSpeed Maintenance plan cleanup history fails with error code 0xC002F210 - SQL 2022 (4376875)