Very good article. I have a few questions after reading your article where I'm not clear on for my "Side by Side Upgrade." I'm going to perform the following "check list" of steps from a SQL 2000 SP4 to SQL 2008 in a side by side upgrade:
1. Install SQL 2008 on my new server.
2. Run the SSUA on the new server to find all the issues with the databases on the SQL 2000 server.
3. Clean up any issues reported by the SSUA.
4. Ensure database consistency by running DBCC CHECKDB on all the system and user databases on
the SQL 2000 server.
5. Backup the SQL 2000 databases including the system databases.
6. Restore all the databases including the system databases on the SQL 2008 server.
Question: System databases first then user databases?
Now this is where a big question came to mind when I was reading your "During upgrade" section. This section seems to imply that we are running Setup.exe from the DVD. Is this for an "In-place Upgrade? I got confused reading this section as it relates to my "Side by Side Upgrade" approach. As it is written it seems to imply that I installing SQL 2008 at this point.
7. Revisit SSUA recommendations
8. Update statistices
9. Run DBCC UPDATEUSAGE on all databases, including system databases.
I'm sure I'll find a few "fun" items along the way. Thank you in advance for answering my questions, and helping me get it all clear.