• thanks for your reply.

    I have another question

    On one server there four instance of sql 2008 we need to upgrade it to 2008 r2. we will use inplace upgrade to upgrade on instance at a time.

    Please let us know what do we need to take care of and what will be the rollback plan.