SQL Server Performance

problem in executing optimization job

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by gnreddy06, Dec 29, 2006.

  1. gnreddy06 New Member

    I have created an optimization schedule for a database. But the job is failed by reporting the following error.

    sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

    can any body help in this regard?

    Narasimha reddy
  2. MohammedU New Member

    I don't think we can conclude anything based on this error...
    Check the maintenance plan output/report file for more details..and Maintenance plan history...
    Check the sql error log too for any errors during this time...
    Make sure you don't repair your db in this optimization job because db has change to single user mode to repair...
    if you are running backups in this job... make sure you have enough space for backups...

    Mohammed U.
  3. gurucb New Member

    Look at application / system logs / error logs / agent logs this is a very generic error message raised by ODBC adn does not indicate issues.
  4. satya Moderator

Share This Page