This session will present techniques for minimizing downtime during database upgrades. We’ll look at what’s required to deliver a reliable database upgrade while maximizing data availability. During the session I will present my own upgrade checklist, relevant whether you’re upgrading to SQL Server 2005 or SQL Server 2008. We’ll consider all aspects of upgrade planning, testing and preparation - including upgrading system databases, options for high availability upgrade, ensuring predictable post-upgrade performance and data consistency.
Presented by Justin Langford at SQLBits III
WMV Video 286 MB