Post reply

Maintenance plan for rebuilding all the indexes failed

  • November 28, 2010 at 11:44 pm

    #157335

    Hi All,

    I scheduled maintenance plan for rebuilding all the indexes in sql server 2005. But it failed with the following error.

    " failed with the following error: "Transaction (Process ID 62) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters

    not set correctly, or connection not established correctly.

    I understand that it has been chosen as victim of deadlock.

    how can I sove this issue ..? No other jobs are running during that 3 hours time anyway. Please let me know what are the steps to be taken so that it rebuilds indexes successfully.

    Thanks in advance.

  • November 29, 2010 at 1:12 am

    #1256134

    Some other process (not necessarily a job) is causing the Reindex job to be deadlocked. Please go through this article[/url] which helps you to troubleshoot deadlocks.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • November 29, 2010 at 1:21 am

    #1256137

    Thanks Adiga.

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

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