locked
Is there any rollback plan if upgrade from sql server 2008 to 2008 r2 fails? RRS feed

  • Question

  • As currently I wish to upgrade a sql server 2008 which is in production.

    Would like to know the rollback steps

    How to change back to sql server 2008 if upgrade fails?

    • Moved by Olaf HelperMVP Tuesday, November 26, 2013 8:52 AM Moved from "SQL Database Engine" to a more related forum
    Tuesday, November 26, 2013 5:40 AM

Answers

  • As currently I wish to upgrade a sql server 2008 which is in production.

    Would like to know the rollback steps

    How to change back to sql server 2008 if upgrade fails?

    Side by side migration has rollback plan in terms of fact that original instance is present. In place upgrade does not rollback plan but VM snapshot backup can be useful(if VM is in picture) , if you have taken backup of all user and system databases with all jobs and logins it would be a great benefit.

    Have you faced any error please post it ,I would like to have a look at it.

    You should always choose for side by side approach if you have complex DB scenario with SSIS packages and SSAS cubes.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    Tuesday, November 26, 2013 5:56 AM
  • so is it possible to go back from sql server 2008 r2 to sql server 2008 without uninstalling it and reinstalling again?

    Yes of course if you use Side by side method of migration.

    Create a new instance of SQL server 2008 r2 migrate databases logins and jobs to new server .Test application to new server if good point application to new server if not old server is as it is

    consider this link if you have SSIS ,SSRS SSAS migration from 2008 to 2008 R2

    http://technet.microsoft.com/en-us/library/bb677619(v=sql.105).aspx


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Proposed as answer by Fanny Liu Wednesday, November 27, 2013 8:01 AM
    • Marked as answer by Fanny Liu Tuesday, December 3, 2013 8:55 AM
    Tuesday, November 26, 2013 6:25 AM
  • A rollback from that would require a machine backup which you restore or snapshot of the machine if it is virtual) and revert to that snapshot.

    Tibor Karaszi, SQL Server MVP | web | blog

    • Proposed as answer by Fanny Liu Wednesday, November 27, 2013 8:01 AM
    • Marked as answer by Fanny Liu Tuesday, December 3, 2013 8:55 AM
    Tuesday, November 26, 2013 6:43 PM

All replies

  • Hi ZO802361,

    As such there is no rollback steps migration fails (Tool can do basic rollback). Whenever you do the migration, It always the responsibility migration expert to create whole rollback strategy, For example backing up the database. It also depends what kind of migration you are doing:

    1.) Side by Side Migration. (Create two identical system and switching to migrated system when fully migrated.) - More control and more efforts

    2.) In Place Migration. (Migrating the same instance) 


    Regards Harsh

    Tuesday, November 26, 2013 5:47 AM
  • As currently I wish to upgrade a sql server 2008 which is in production.

    Would like to know the rollback steps

    How to change back to sql server 2008 if upgrade fails?

    Side by side migration has rollback plan in terms of fact that original instance is present. In place upgrade does not rollback plan but VM snapshot backup can be useful(if VM is in picture) , if you have taken backup of all user and system databases with all jobs and logins it would be a great benefit.

    Have you faced any error please post it ,I would like to have a look at it.

    You should always choose for side by side approach if you have complex DB scenario with SSIS packages and SSAS cubes.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    Tuesday, November 26, 2013 5:56 AM
  • so is it possible to go back from sql server 2008 r2 to sql server 2008 without uninstalling it and reinstalling again?
    Tuesday, November 26, 2013 6:10 AM
  • so is it possible to go back from sql server 2008 r2 to sql server 2008 without uninstalling it and reinstalling again?

    Yes of course if you use Side by side method of migration.

    Create a new instance of SQL server 2008 r2 migrate databases logins and jobs to new server .Test application to new server if good point application to new server if not old server is as it is

    consider this link if you have SSIS ,SSRS SSAS migration from 2008 to 2008 R2

    http://technet.microsoft.com/en-us/library/bb677619(v=sql.105).aspx


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Proposed as answer by Fanny Liu Wednesday, November 27, 2013 8:01 AM
    • Marked as answer by Fanny Liu Tuesday, December 3, 2013 8:55 AM
    Tuesday, November 26, 2013 6:25 AM
  • Are you doing an in-place or side-by-side upgrade?

    Tibor Karaszi, SQL Server MVP | web | blog

    Tuesday, November 26, 2013 7:50 AM
  • I am doing an in place upgrade

    updating an existing sql server 2008 engine to sql server 2008 r2 engine

    Tuesday, November 26, 2013 3:00 PM
  • A rollback from that would require a machine backup which you restore or snapshot of the machine if it is virtual) and revert to that snapshot.

    Tibor Karaszi, SQL Server MVP | web | blog

    • Proposed as answer by Fanny Liu Wednesday, November 27, 2013 8:01 AM
    • Marked as answer by Fanny Liu Tuesday, December 3, 2013 8:55 AM
    Tuesday, November 26, 2013 6:43 PM