Database migration from 2005 to 2000

  • Guys,

    What is the best way to migrate 60gb database from SQL Server 2000 to 2005. What are the potential bottlenecks to look out for.

    The database is active between 8pm and 6pm only with a backup window between 12 and 1am.

    The database is set to full recovery mode with Transaction log backups every hour.

    Thanks

  • Either use a backup file or detach, copy, reattach - then fix your users.

    Backup file will take more time since it needs to be created and then copied.

    Moving to 2k5 has been pretty pain-free for us.

  • Once you've done the migation, be sure to update all the statistics and do a checkDB.

    SQL 2005 can use the SQL 2000 statistics, but badly. Queries often run slower until the stats are updated. CheckDB checks more things in 2005 than it did in 2000, so it's a good idea to run it after the upgrade and make sure you have no lingering issues.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply