Native maintenance plan backup job created from LiteSpeed Enterprise Console failed.
Execution fails with error "Executed as user: NT AUTHORITYSYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed."
Script from maintenance plan steps:
execute master.dbo.xp_sqlmaint N'-PlanID A4B6FCB3-019E-4ACF-A652-40B8C196ADBE -BkUpMedia DISK -BkUpDB "C:" -BkExt "bak" -VrfyBackup -BkUpOnlyIfClean '
Steps to Reproduce:
1. Create a maintenance plan with to backup a database using SQL native sqlmaint utility and 'Verify Integrity...' option checked on.
2. Run the job to execute the backup.
3. Note that backup failed.
4. Next manually edit in 'Job' Step code to remove '-BkUpOnlyIfClean' parameter.
5. Run the job to execute the backup again. The process completes with success.
Software Defect
Fixed in Version 5.0
Workaround:
From LiteSpeed Enterprise Console | Management | Jobs | edit job | Steps tab | manually remove -BkUpOnlyIfClean from the Command.
