f you have high availability and disaster recovery solutions in place for your SQL Server instances, proper planning and considerations have to be made to upgrade to SQL Server 2016. In this session, we will look at high availability options in previous versions of SQL Server, including database mirroring, failover clustering, log shipping and replication. We will also learn how to upgrade to SQL Server 2016 with minimal downtime when SQL Server high availability and disaster recovery features are part of the existing configuration.
This session will focus on:
- The considerations for performing an in-place upgrade versus a side-by-side migration
- How to prepare for the upgrade in order be successful
- How to upgrade to SQL Server 2016 with existing database mirroring, failover clustering, log shipping and Availability Group configuration
- How to reduce your downtime and level of effort associated with upgrading SQL Server
Edwin Sarmiento is a SQL Server MVP from Ottawa, Canada specializing in high availability, disaster recovery & system infrastructures running on the Microsoft server technology stack. He is very passionate about technology but has interests in music, professional & organizational development, leadership & management matters when not working with databases. He lives up to his primary mission statement – “To help people and organizations grow and develop their full potential as God has planned for them.”