Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Unanswered: Optimizations job failure - SQLServer2000

    Hi all,
    I created a database maintenance plan with backup + transsactionlog backup+optimizations. The first two jobs work fine but the Optimizations job is failing with error:
    sqlmaint.exe failed. SQLSTATE 42000, Error: 22029. The step failed.

    User is admin on local box and "sysadmin" in db server role. Any suggestions to resolve this?

    Thanks
    Vinnie

  2. #2
    Join Date
    May 2003
    Location
    Rochester, NY
    Posts
    135

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •