Migrating from SQL 2008 to SQL 2008 R2

• aviadavi

  SSC Veteran

  Points: 258

  More actions

  February 26, 2013 at 9:24 am

  #271347

  Hi,

  We need to migrate our DB from using SQL 2008 to SQL 2008 R2.

  What do you suggest to check ?

  BR,

  Aviad

• WWDMark

  Hall of Fame

  Points: 3157

  More actions

  February 26, 2013 at 9:34 am

  #1591243

  aviadavi (2/26/2013)

  ---

  Hi,

  We need to migrate our DB from using SQL 2008 to SQL 2008 R2.

  What do you suggest to check ?

  BR,

  Aviad

  Hi, have a look at the 'prerequisites' section in this link: http://msdn.microsoft.com/en-gb/library/ms144267(v=sql.105).aspx it covers things like parameters for system config, hardware/software requirements , backwards compatibility etc.

  May help.

  ---

  MCITP
  MCTS - E-Business Card
  Twitter: WWDMark

  ---

  
  Try not! Do or do not, there is no try

  email: info@weekendwebdesign.co.uk
  Personal Website: http://markallen.co.uk/
  Business Website: https://www.weekendwebdesign.co.uk

• RP_DBA

  SSCertifiable

  Points: 5116

  More actions

  February 26, 2013 at 11:16 am

  #1591275

  I found the SQL Server Upgrade Advisor to be helpful in identifying potential issues.

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

  _____________________________________________________________________
  - Nate

  @nate_hughes