database migration from 2000 to 2008

• brave heart

  SSC Enthusiast

  Points: 104

  More actions

  June 3, 2010 at 11:06 am

  #143367

  HI,

  Can anyone help me with the database migration from 2000 to 2008 using the backup restore approach.I am new to migration and I know that we have to take a backup of the 2000 database and restore it in 2008 and change the compatibility mode.but I need a detailed procedure,pre migration tasks and post migration tasks.Please help me with the needed info and links.Thank you.

• CavyPrincess

  Hall of Fame

  Points: 3336

  More actions

  June 3, 2010 at 11:38 am

  #1176101

  Here's a useful link that should help you.

  http://www.sqlservercentral.com/Forums/Topic914723-391-1.aspx

  Cindy

• brave heart

  SSC Enthusiast

  Points: 104

  More actions

  June 3, 2010 at 12:27 pm

  #1176121

  Thank you very much.