Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Location
    Hertfordshire, England
    Posts
    78

    Question Unanswered: Upgrade/Move DB from 2000 to 2005

    I need to get some databases from SQL 2000 to 2005. Is it a simple case of detach from 2000 and attach to 2005? Or is there something more complicated to do?

    Both SQL 2000 and 2005 are on the same server and the 2005 is a named instance.

    Thanks.

  2. #2
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    I prefer to backup then restore from 2000 -> 2005.

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Backup restore
    George
    Home | Blog

  4. #4
    Join Date
    Aug 2009
    Posts
    262
    wait for 5 years for it to grow up .

  5. #5
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by NeilA View Post
    I need to get some databases from SQL 2000 to 2005. Is it a simple case of detach from 2000 and attach to 2005? Or is there something more complicated to do?

    Both SQL 2000 and 2005 are on the same server and the 2005 is a named instance.

    Thanks.
    You can detach/copy/attach or backup/copy/restore.

    I tend to prefer detach/copy/attach because then I'm certain that nothing is left pointing at the old database on the old server. If you choose the backup/copy/restore route, be sure to set the old database offline (or detach it from the old instance). I can't tell you the number of times that this has saved us from the old "uh, oh, I forgot about that batch process" problem.

    Regards,

    hmscott


    PS. Be sure to check the following items/perform the following tasks once the migration is complete:

    1) Set the compatibility/version to 2005 (unless there is a compelling reason not to)

    2) Set page verify to CHECKSUM

    3) Perform dbcc updateusage(0) in the new database

    4) Perform dbcc checkdb in the new database

    5) Perform sp_updatestats in the new database

    6) Make a full backup of new database
    Last edited by hmscott; 01-06-10 at 23:36.
    Have you hugged your backup today?

Posting Permissions

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