August 27, 2009 at 3:43 am
Hi,
I've scheduled DB backup & integrity checks job for some 12 DB in the single maintenance plan.
Since one year it was working fine. But last 2 days it is giving an error msg in job history like
"Executed as user: XXX\sysservices. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.".
DB Backup & Integrity checks was happened perfectly.
Even in the Maintenance Plan History also there is no failed flag.
Can any one please help me to sort out this.
August 27, 2009 at 8:44 am
You need to look at the maint plan log. It's usually a text file in the /log folder. It has more details. If you don't log from the maint plan, change that. Run the wizard and be sure it's logging.
August 28, 2009 at 1:08 am
Thanks for ur imm response. We haven't enabled the log for maint plan.
But surprisingly today our job was succeeded.
Anyway i will enable the 'Text Reports' option & will check for some other days.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply