How to approach zero downtime database upgrades
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.
Justin is a Principal Consultant for Coeo, a Microsoft Gold Partner providing SQL Server consulting services for upgrade, performance tuning, scalability and availability solutions for SQL Server. Coeo also offer Remote DBA services for mission critical SQL Server platforms. Justin is an MVP and co-authored Wrox IT Pro: SQL Server 2012 Internals and Troubleshooting, as well as the same title for SQL Server 2008 and SQL Server 2005 Performance Tuning.