The topic isn't small to answer in few lines, whenever you perform a database upgrade from previous version to current version the steps may be same but not the approach. The whole update task is a complex and sometimes prove risky if proper testing...
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Wed, Sep 8 2010
Filed under: Filed under: application, sql server, tools, upgrade, best practices, r2, upgrade advisor, database consistency, ssua, upgrade assistant