Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    32

    Unanswered: Moving from SQL 2005 to SQL 2008

    We are going to move our production SQLs from SQL 2005 Standard edition to SQL 2008 Standard Edition; we are moving to a completly new box, so the plan is to do a restore from backups; what is the best way to approach the move of the following:

    - MSDB
    - Login Information from Master
    - Replcation - we are currently replicating a database in the same box for reporting purposes

    Any suggestion would be greatly appreciated.

    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I would:

    1) install SQL 2005 Stamdard Edition onto your new hardware
    2) restore your database backups. including master and msdb
    3) test to see that things work on the new machine
    4) upgrade in place to SQL 2008 R2 Standard Edition

    This adds a tiny bit of work to your upgrade process, but will save you hours or days because it will transfer EVERYTHING without exception... When something breaks at quarter or year end, you have no lingering doubts about possibly having forgotten something in the transfer process.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •