Production Move

• AAKR

  SSCommitted

  Points: 1586

  More actions

  May 1, 2013 at 3:47 pm

  #277334

  Hi All,

  I am going to a move a server to production. The present production is 2005 enterprise, now i am going to move this production to 2008 r2 slandered.

  Here is my Question

  What are the steps to follow to move server to production?

  If something happen to the production what are the steps to rollback?

  Could you please give me some suggestions?

  In advance

  Thank you 

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  May 1, 2013 at 8:32 pm

  #1611768

  AAKR (5/1/2013)

  ---

  Hi All,

  I am going to a move a server to production. The present production is 2005 enterprise, now i am going to move this production to 2008 r2 slandered.

  Here is my Question

  What are the steps to follow to move server to production?

  If something happen to the production what are the steps to rollback?

  Could you please give me some suggestions?

  In advance

  Thank you ?

  Start by running the Upgrade Advisor against your current databases and resolve any recommendations it makes regarding compatibility. Since you are moving from Enterprise Edition to Standard Edition you'll also want to make sure you are not using any Enterprise-only features that may cease to function when you migrate.

  My preference is to install a new instance so that in the event the migration goes poorly and we do not proceed on the new instance, we simply bring operations back online on the pre-existing instance.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• Jeff Moden

  SSC Guru

  Points: 1004409

  More actions

  May 1, 2013 at 11:16 pm

  #1611790

  opc.three (5/1/2013)

  ---

  AAKR (5/1/2013)

  ---

  Hi All,

  I am going to a move a server to production. The present production is 2005 enterprise, now i am going to move this production to 2008 r2 slandered.

  Here is my Question

  What are the steps to follow to move server to production?

  If something happen to the production what are the steps to rollback?

  Could you please give me some suggestions?

  In advance

  Thank you ?

  Start by running the Upgrade Advisor against your current databases and resolve any recommendations it makes regarding compatibility. Since you are moving from Enterprise Edition to Standard Edition you'll also want to make sure you are not using any Enterprise-only features that may cease to function when you migrate.

  My preference is to install a new instance so that in the event the migration goes poorly and we do not proceed on the new instance, we simply bring operations back online on the pre-existing instance.

  +1 to all of that.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)