SQL Server 2005 Migration Best practices

• day-476284

  SSCommitted

  Points: 1844

  More actions

  July 10, 2008 at 3:25 pm

  #122403

  Hi all,

  We are planning to move SQL2KS-SP4 to SQL2K5-SP2.

  Currently, SQL2KS-SP4 is running in the MACHINE1.

  GOAL: At the end of the migration, we want only one instance "SQL Server 2005" should run in the MACHINE1.

  CHALLENGE: After uninstalling 2000, If something goes wrong we might need to roll back to 2000.

  1) Install SQL2K5-SP2 in the MACHINE2.

  2) Create all logins in 2005 by scripting them out from 2000

  3) "Backup/Restore" all user databases OR use "Copy Database Wizard" to copy them.

  4) Test the 2005 environment in MACHINE2.

  5) If everything is fine, uninstall all 2000 instances in MACHINE1

  6) Install SQL2K5-SP2 in MACHINE 1.

  7) Backup system databases from MACHINE2

  8) Start SQL2K5-SP2 as single user mode in MACHINE1

  9) restore master DB into MACHINE1

  10) "Backup/Restore" all user databases OR use "Copy Database Wizard" to copy them.

  11) Test the 2005 environment in MACHINE1

  12) If everything works fine, install SQL2K5-SP2 from MACHINE2.

  Our Question is:

  ============

  In step 3 and 10, which method we should apply?

  "Backup/Restore" OR "Copy Database Wizard"

  Thanks,

• Jayakumar Krishnan

  SSCarpal Tunnel

  Points: 4710

  More actions

  July 10, 2008 at 4:07 pm

  #841155

  Backup and restore will help well instead of the Wizard option.

  Also check this link, will give more idea.

  http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=162455&SiteID=1

  Good luck...

  Thanks
  Jay
  http://www.sqldbops.com