August 26, 2008 at 1:47 pm
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
August 26, 2008 at 2:12 pm
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.
August 26, 2008 at 2:34 pm
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply