Steps for Migration to SQL Server 2005

[Steffi1013]

I am doing an migration from SQL 2K to 2K5 and was wondering if there is anything I am missing. I am moving it from one server to a brand new super powerful server and have tested it many times but wanted to double check that I am not missing anything important.
1. Detach old DB and reattach to new server
2. Change owner of db
3. Run login script
4. Change DB's to 9.0 compatability
5. Run DBCC UpdateUsage
6. Run DBCC CheckDB
7. Run DBCC CheckCatalog
8. Run Update Statistics with Full Scan
9. Run Reindex on all Tables

Is there a different order for the dbcc's that I should be running them or should I run other ones?

Any help would be appreciated.
TIA

 

[ptheriault]

you should run 9 before 8. you reindex your tables then update the stats. But other than that you got it covered.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[Steffi1013]

Ok - so I should run Reindex before running Update Stats?? What are the benefits??

 

[ptheriault]

Statistics are used by the query optimizer to determine the best query plan. If you reindex after you update stats, your stats are old. You could get a bad query plan for a query. So you should update stats after reindexing.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[Steffi1013]

Thanks Paul for the information. I really appreciate it. I will change those steps on my upgrade plan.

Am I missing anything else that anyone can see in the upgrade plan?

 

[ptheriault]

No problem,
Don't forget to backup your database and Tlog.


- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[Steffi1013]

Thank you! They are being backed up to tape before the detach portion of the process.