Post reply

rollback on index job?

  • April 7, 2006 at 9:04 am

    #113670

    I ran an index job (via maintenance plan wizard) and it ran much longer than I expected.

    I killed the job and now it's in a rollback condition.  Will it rollback the built indexes on all tables that were completed?  or just one that it was currently reindexing at the time of the kill?

    Thanks!

  • April 10, 2006 at 6:53 am

    #631695

    It should not have any impact on the indexes that are already built. Every index will be built as transaction, to my understanding the last one which is in process will get rolled back.

     

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

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

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