Home Forums SQL Server 2005 Administering reindex maintenance plan failed in sql 2008 (An item with the same key has already been added) RE: reindex maintenance plan failed in sql 2008 (An item with the same key has already been added)

  • November 13, 2016 at 12:50 am

    #1912101

    I'm going to guess it's a bug in the portion of SSIS that executes maintenance plans (since, on second look, it looks like it might be a .net error)

    Patch the server (There's 4 service packs for 2008 R2 iirc, you shouldn't be running RTM by this point), patch the client as well (SSMS) and seriously consider replacing the maint plan with Ola's scripts, as they're far better.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass