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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center