In this session, we will provide a SQL Server 2008 upgrade overview. The session will cover the essential phases and steps involved in upgrading SQL Server 2000, SQL Server 2005, and SQL Server 2008 to SQL Server 2008 R2 by using best practices and available resources. We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. This session will also cover upgrading a stand-alone instance; upgrading a clustered instance; upgrading instances involved in mirroring, log shipping, and replication; feature-specific considerations; and recommended tools for a successful upgrade.
For more information, check out this course on Microsoft Virtual Academy: