This session provides an in-depth look at how to upgrade to SQL Server 2008 R2 or how to upgrade to the next major release of SQL Server called SQL Server "Denali". The session covers the essential phases and steps involved in upgrading from SQL Server 2000, SQL Server 2005, SQL Server 2008 to SQL Server 2008 R2 or SQL Server "Denali" by using best practices and available resources. We cover the complete upgrade cycle, including the preparation tasks, upgrade tasks and post-upgrade tasks. This session covers 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. Several demos are given covering the process and the available tools. The new SQL Server "Denali" feature called “Product Update”, the next version of SQL Server slipstream is also covered showing you how to discover critical updates that you should include when installing or upgrading to SQL Server "Denali".
For more information, check out this course on Microsoft Virtual Academy: