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.
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.
Beginning with SQL Server 2016 you will have the ability to store portions of a database in the cloud. Tim Radney introduces Stretch Database by looking at the applications and limitations of the new feature.
I'm watching your topic with interest, and hoping for replies from the gurus as well. One key piece of info that would help your cause would be knowing what version of SQL server you are running. We (still) only have Version 7 here and I know that the replication functions have been improved immensely starting […]