Post reply

In Place upgrade rollback

  • December 12, 2014 at 11:35 am

    #313871

    Hi -

    I will be performing an active/active in place upgrade from SQL 2008 to SQL 2012 in two nodes, and I needed to know the rollout plan in case things go wrong. I read that for in-place upgrade, there is no rollout plan (I can't just uninstall the changes). I already have setup an environment where I migrated all databases from both nodes there as a backup plan. However I would like to know the answer to whether I can roll back or not.

    Thanks.

  • December 12, 2014 at 1:59 pm

    #1764572

    Let me correct myself, there is a rollout plan however it is not simple. The process involved uninstalling SQL 2012, reinstalling SQL 2008 and restoring databases. I just did not know if there is any better way which I am not aware of to do a quick rollout. In our shop we do not do image backup/restore so I will not have disk backup to restore from.

  • December 13, 2014 at 5:17 am

    #1764601

    You can't really undo an in-place upgrade. You would have to uninstall everything and then restore your databases from a backup. You're pretty much making a commitment by doing your upgrade this way.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • December 15, 2014 at 6:29 am

    #1764706

    Grant - Thank you. I already setup another environment to restore to in case of failure as I understood that there is not an easy way to rollout in-place upgrade unless you uninstall everything and reinstall SQL 2008.

    Thanks for your input.

  • December 17, 2014 at 1:22 am

    #1765087

    And bear in mind that you can't downgrade SQL databases. Once the databases are attached to a SQL 2012 instance, they are SQL 2012 databases and will not attach or restore to SQL 2008

    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

  • December 17, 2014 at 6:20 am

    #1765153

    definitely.. I am taking backups prior to the upgrade and restore them else were in case of emergency. I already have two servers for that purpose.

Viewing 6 posts - 1 through 5 (of 5 total)

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