Implementing Stretch Database

Learn how you can enable the Stretch Database feature in SQL Server 2016.

Introduction to SQL Server Stretch Database

In many cases Azure SQL Database offers an economically and functionally viable alternative to SQL Server deployments. However, there are also scenarios where we might discover that rather than serving as a replacement, it provides synergy, working side by side with your on-premises databases. One of technologies that illustrate this paradigm is Stretch Database, introduced in SQL Server 2016. Marcin Polichtdescribes its basic characteristics and reviews its implementation steps in this article.

Stretch Database Datatype Limitations

Getting Started with Stretch Database Functionality in SQL Server 2016 - Part 2

Arshad Ali explains and demonstrates the impact of enabling the Stretch database feature on backup and restore operations. He also discusses ways to pause, resume, and disable this feature altogether when not needed.

Stretch Database in SQL Server 2016 RTM

Tim Radney of SQLskills shows how the Stretch Database feature has evolved from its early CTP beginnings to the RTM version released earlier this month.