To successfully upgrade your SQL Server instances you need to prepare for the upgrade process with comprehensive planning and follow the best practices during the upgrade process. Otherwise, you can run into costly errors, upgrade problems and downtime.
Best Practices for Upgrading SQL Server 2008/R2