April 19, 2007 at 12:57 pm
Hello,
We are going to upgrade SQL 2000 SE to SQL 2005 SE. We decided to install SQL Server 2005 on a new machine and migrate databases to it. In this case, do I still need to run Upgrade Advisor on sql 2000.
Can I just use attach and detach or database restore method?
Any advice is very much appreciated!
April 19, 2007 at 1:19 pm
Definately still run the Analyzer to detect any features that you currently use that are deprecated. It also wouldn't hurt to run some .trc files collected from your production server through analyzer.
April 19, 2007 at 1:39 pm
It is also recommmended to run dbcc checkdb with data_purity on each database immediately after you upgrade.
You should also remember to update the statitsics on your databases afetr the upgrade as well
David
April 19, 2007 at 1:57 pm
Thank you for the answers!
Would you mean I can still use detach and attach method?
April 19, 2007 at 2:01 pm
Yup you can detach and attach to your hearts content.
David
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply