Post reply

maint plan failed

  • June 28, 2013 at 1:22 am

    #276782

    My manitainence plan failing with the following error

    [SQLSTATE 42000] (Error 14650).

    how to resolve this ?

  • June 28, 2013 at 1:47 am

    #1628216

    Are there things changed on your instance (databases removed, recovery modes changed, etc.)?What are the steps and actions you've defined in your maintenance plan? Do you run the maintenance plan on different schedules and seperated steps? Can you see in the job-history which step(s) are failing?

    Try to figure out what part of the maintenance plan is failing. Also try to figure out if it fails on a specific database.

    Bottom line: we need a lot more information before we can point you to a possible solution...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • June 28, 2013 at 2:58 am

    #1628230

    Check the maintenance plan history or the Maintenance plan logfile if you have one configured.

    Jobhistory won't give you the error details.

    [font="Verdana"]Markus Bohse[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply